Excel

Name Ranges in Excel
https://pupli.net/2019/11/11/name-ranges-in-excel/

Excel SUMIF function
https://pupli.net/2019/11/12/excel-sumif-function/

Excel Expanding Reference or Expanding Range
https://pupli.net/2019/11/excel-expanding-reference-or-expanding-range/

Excel Array formula
https://pupli.net/2019/11/excel-array-formula/

Excel INDEX Function
https://pupli.net/2019/11/excel-index-function/

Excel MATCH Function
https://pupli.net/2019/11/excel-match-function/

Use INDEX and MATCH Formula in Excel
https://pupli.net/2019/11/use-index-and-match-formula-in-excel/

Extract unique items from a list in Excel
https://pupli.net/2019/11/extract-unique-items-from-a-list-in-excel/

Excel ROW Function
https://pupli.net/2019/12/excel-row-function/

Convert text to number with VALUE formula in Excel
https://pupli.net/2019/12/convert-text-to-number-with-value-formula-in-excel/

Sort Numeric Columns in Excel using Formulas
https://pupli.net/2019/12/sort-numeric-columns-in-excel-using-formulas/

Check If cell is blank in Excel
https://pupli.net/2019/12/check-if-cell-is-blank-in-excel/