What is INDEX function in Excel?
INDEX function is one of Lookup and Reference functions … Read More
Basic text sort formula in Excel
To dynamically sort text values in alphabetical order, you can use use a formula based … Read More
How to calculate two-way lookup VLOOKUP in Excel Table
To do a two-way lookup in an Excel Table, you can use the MATCH function … 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 create running total in an Excel Table
This tutorial shows illustrates a Running total in Excel Table.
To create a running total … Read More
How to calculate average last N values in a table in Excel
To calculate the average for the last N values n an Excel table (i.e. last … Read More
Get column name from index in Excel Table
To get the name of a column in an Excel Table from its numeric index, … Read More
Last row number in range
You can get the last row in a range with a formula based on the … Read More
How to get last column number in range in Excel
You can get the last column in a range with a formula based on the … Read More
How to get relative row numbers in a range in Excel
To get a full set of relative row numbers in a range, you can use … Read More
How to get first row number in range in Excel
You can get the first row (i.e. the starting row number) in a range with … Read More
How to retrieve first match between two ranges in Excel
To retrieve the first match in two ranges of values, you can use a formula … Read More
How to create dynamic named range with INDEX in Excel
This tutorials show examples one and two dynamic named ranges created.
The first is created … Read More
How to get random value from list or table in Excel
To get a random value from a table or list in Excel, you can use … Read More
How to generate random number weighted probability in Excel
To generated a random number, weighted with a given probability, you can use a helper … Read More
List sheet names with formula in Excel
To list worksheets in an Excel workbook, you can use a 2-step approach: (1) define … Read More
Find most frequent text within a range with criteria in Excel
To find the most frequently occurring text in a range, based on criteria you supply, … Read More
Extract most frequently occurring text in Excel
To extract the word or text value that occurs most frequently in a range, you … Read More
How to find and replace multiple values at same time in Excel
To find and replace multiple values with a formula, you can nest multiple SUBSTITUTE functions … Read More
How to calculate next scheduled event in Excel
To get the next scheduled event from a list of events with dates, you can … Read More
Categorize text with keywords in Excel
This tutorial shows how to Categorize text with keywords in Excel using the example below;… Read More