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/

Check Cell contains specific text in Excel
https://pupli.net/2020/05/check-cell-contains-specific-text-in-excel/

Excel COUNTIF Function
https://pupli.net/2020/05/excel-countif-function/

Get decimal part of a number in Excel
https://pupli.net/2020/05/get-decimal-part-of-a-number-in-excel/

If cell equals in Excel
https://pupli.net/2020/05/if-cell-equals-in-excel/

Remove special characters from excel cell using macro
https://pupli.net/2020/07/remove-special-characters-from-excel-cell-using-macro/