To convert a column letter to an regular number (e.g. 1, 10, 26, etc.) you … 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 column numbers in a range in Excel
This tutorial shows how to get a full set of relative column numbers in a … Read More
How to get address of last cell in range in Excel
To get the address of the first cell in a named range, you can use … Read More
How to get address of named range in Excel
To get the full address of a named range with an Excel formula, you can … Read More
How to get first column number in range in Excel
You can get the first column (i.e. the starting column number) in a range with … Read More
How to get address of first cell in range in Excel
To get the address of the first cell in a named range, you can use … Read More
Merge tables with VLOOKUP in Excel
This tutorial shows how to Merge tables with VLOOKUP in Excel using the example below;… Read More
Index and match on multiple columns in Excel
This tutorial shows how to calculate Index and match on multiple columns in Excel using … Read More
Get location of value in 2D array in Excel
This tutorial shows how to Get location of value in 2D array in Excel using … Read More
Max of every nth column in Excel
This tutorial shows how to calculate Max of every nth column in Excel using the … Read More
Count rows that contain specific values in Excel
This tutorial shows how to Count rows that contain specific values in Excel using the … Read More
Count rows with at least n matching values
This tutorial shows how to Count rows with at least n matching values using the … Read More
Sum every nth column in Excel
This tutorial shows how to Sum every nth column in Excel using the example below;… Read More
How to use Excel COLUMN Function
This Excel tutorial explains how to use the COLUMN function with syntax and examples.