Convert Column to Number Formula in Excel
Link to full course: https://commercecurve.com/ultimate-ex...
Take this course if you're looking to accelerate your career with a complete course that integrates finance and accounting topics with end-to-end Excel training through the application of concrete examples of real world companies.
This formula is used to find out the number of any column letter (e.g. A,B,C,D, etc). This can have many purposes. For instance, in the OFFSET formula, we make reference to a specific cell and then the lookup to that cell can be offset by the number of rows or columns from it. If you use the COLUMN formula, you can count how many columns away a particular cell is.
There are two ways in which we can use the COLUMN formula:
1) =COLUMN(REFERENCE CELL)
This formula will return the column number of the reference cell.
2) =COLUMN(INDIRECT(ref_text, [a1]))
This formula will allow you enter a column letter in the ref_text part of the formula to return the column number of that column letter.
COLUMN: To get the column number.
INDIRECT: To find the ref_text.
ref_text: Cell containing the column letter for which we are finding it's number.
a1: Logical value that helps to specify the reference.