Worksheet function?
This will return the number of the column (I used row 1):
=MAX(ISNUMBER(1:1)*COLUMN(1:1))
This will return the address of the cell:
=ADDRESS(1,MAX(ISNUMBER(1:1)*COLUMN(1:1)))
For both of these formulas:
instead of just hitting enter, hit ctrl-shift-enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)
