Want to pick up cell column id of first non-blank cell in a row

[noceps]

Want to pick up cell column id of first non-blank cell in a row.

For example ....

A B C D E F
1 5 5 5
2 5 5 5
3 5
4 5 5
5 6

I want to automatically know that for Row 1 the first entry with a number is Column B.

In Row 2 it will be C, Row 3 it will be F, and so on.

Regards Ray

[SteveG]

Ray,

If you just want the letter that represents the column then you could use,

=CHOOSE(MIN(IF(ISNUMBER(A2:F2),COLUMN(A2:F2))),"A","B","C","D","E")

Array formula committed with Ctrl+Shift+Enter not just enter. If you want the cell address (A1, B1, C1 etc...)

=ADDRESS(ROW(A2),MIN(IF(ISNUMBER(A2:F2),COLUMN(A2:F2))),4)

Again an array formula. If just want the column number then,

=MIN(IF(ISNUMBER(A2:F2),COLUMN(A2:F2)))

Also an array formula.

HTH

Steve