Convert column letter to number in Excel
February 16, 2019
How to create dynamic reference table name in Excel
February 15, 2019
Example of COUNTIFS with variable table column in Excel
February 15, 2019
How to strip non-numeric characters in Excel
February 14, 2019
How to translate letters to numbers in Excel
February 14, 2019
List worksheet index numbers in Excel
February 14, 2019
How to check worksheet name exists in Excel
February 14, 2019
How to create dynamic worksheet reference in Excel
February 13, 2019
Create dynamic workbook reference to another workbook in Excel
February 13, 2019
Get work hours between dates custom schedule in Excel
February 11, 2019
How to abbreviate names or words in Excel
February 11, 2019
How to convert text string to array in Excel
February 11, 2019
Count day of week between dates in Excel
February 8, 2019
Excel Data validation specific characters only
February 7, 2019
Uncategorized
Lookup with variable sheet name in Excel
February 4, 2019
Uncategorized
Get cell content at given row and column in Excel
February 4, 2019
Uncategorized
Dynamic lookup table with INDIRECT in Excel
February 3, 2019
Uncategorized
Average the last 3 numeric values in Excel
February 3, 2019
Uncategorized
Count occurrences in entire Excel Workbook
February 2, 2019