Use Excel COLUMN Function to get the column number of a reference. In simple words, it will return a number which represents the column number of the reference.
For example, if you refer to cell A3 it will return 1 in the result as A’s column number is one.
- reference A cell reference for which you want to get the column number.
More Information on Excel COLUMN Function
- You cannot refer to multiple references.
- If you refer to an array, column function will also return the column numbers in an array.
- If you refer to a range of more than one cell, it will return the column number of the leftmost cell. For example, if you refer to the range A1:C10, it will return column number of the cell A1.
- You skip to specify a reference, it will return the column number of the current cell.
In the below example, I have used column function to the get the column number of the cell A1.
As I have already mentioned, if you skip specifying cell reference it will return the column number of the current cell. In the below example, I have used column function create a header with serial numbers.
To learn more about Excel AVERAGE Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.