Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Lookup Reference Functions

 

COLUMN(reference) returns the column number of a reference

Input the formula: =COLUMN(A10). Press Enter to get the result.