To convert a column letter to an regular number (e.g. 1, 10, 26, etc.) you … Read More
How to create dynamic reference table name in Excel
To build a formula with a dynamic reference to an Excel Table name, you can … Read More
Example of COUNTIFS with variable table column in Excel
To use COUNTIFS with a variable table column, you can use INDEX and MATCH to … Read More
How to strip non-numeric characters in Excel
To remove non-numeric characters from a text string, you can try this experimental formula based … Read More
How to translate letters to numbers in Excel
To translate letters in a string to numbers, you can use an array formula based … Read More
List worksheet index numbers in Excel
To list the index numbers of sheets in an Excel workbook, you can enter the … Read More
How to reference named range different sheet in Excel
This tutorials shows how to reference a named range on another sheet.
To achieve this, … Read More
How to check worksheet name exists in Excel
To test if a worksheet name exists in a workbook, you can use a formula … Read More
How to create dynamic worksheet reference in Excel
To create a formula with a dynamic sheet name you can use the INDIRECT function.… Read More
Create dynamic workbook reference to another workbook in Excel
To build a dynamic worksheet reference – a reference to another workbook that is created … Read More
Get work hours between dates custom schedule in Excel
To calculate work hours between two dates with a custom schedule, you can use a … Read More
How to abbreviate names or words in Excel
To abbreviate text that contains capital letters, you can try this array formula based on … Read More
How to convert text string to array in Excel
To convert a string to an array that contains one item for each letter, you … Read More
Count day of week between dates in Excel
This tutorial shows how to Count day of week between dates in Excel using example … Read More
Excel Data validation specific characters only
Set criteria to accept specific characters only
To use data validation to allow a list
Lookup with variable sheet name in Excel
This tutorial shows how to Lookup with variable sheet name in Excel using the example … Read More
Get cell content at given row and column in Excel
This tutorial shows how to Get cell content at given row and column in Excel … Read More
Dynamic lookup table with INDIRECT in Excel
This tutorial shows how to calculate Dynamic lookup table with INDIRECT in Excel using the … Read More
Average the last 3 numeric values in Excel
This tutorial shows how to work Average the last 3 numeric values in Excel using … Read More
Count occurrences in entire Excel Workbook
This tutorial shows how to Count occurrences in entire Excel Workbook using the example below;… Read More
COUNTIF with non-contiguous range in Excel
This tutorial shows how to COUNTIF with non-contiguous range in Excel using the example below;… Read More