COLUMN
Gives the number of current column or of the reference mentioned
Gives the number of current column or of the reference mentioned
Syntax of Excel Column formula:
=COLUMN([reference])
In words:
=What is the column number(of this cell reference)
[reference] argument is optional. If left out then function will give the column number of current column where formula is inserted. If mentioned then it will give the column number of the referred cell.
=COLUMN(HS76) will give 227
=COLUMN(A1) will give 1
=COLUMN(A1)-1 will give 0