I've been trying to figure out how i can identify the first non blank cell in
a series and show me which column that cell is in. e.g.
Col1 Col2 Col3 Col4 Col5
Row1 34.2 3.45 45.1 432.1
Row2 43.1 541
Row3 34.1 51.12

What formula can i key in Col6, that shows me the for row2,that col2 is the
first non blank number, and for row 3, col3 is the first non blank number and
similarly for Row1, col1 is the first non blank number.

Thanks