To find the column number (instead of letters) use the Column() command. Eg. for columnt 'AE' write in any cell:
=Column(AE1)
The cell then displays 31 which is the numeric column index (starting at 1). The '1' is after AE specifies the row, doesn't matter wich one you specify so seems quite pointless - but it needs to be there.
No comments:
Post a Comment