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.
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.