find first and last in row of numbers

[anand]

I have a sequence of up to 4 numbers in a row (Column A to D). Sometimes
there are #'s in all spots, sometimes in just the first one, any combination
of a random # or blank is possible. Only rule is that there must be a number
in the first position (column A).

I need a formula that will provide the position (numerically, i.e Column B
would be 2, column C would be 3., column 4 would be 4) of the last # in the
sequence. Don't need the value, just the position.

Note that it is possible that the first and last # in the series may be the
same (i.e. the first value of 4 potential is the only value).

Can anyone advise?

 

[T. Valko]

Try this:

=IF(COUNT(A11),MATCH(1E10,A11),"")

 

[Max]

Admit I'm a bit confused by your line:

Only rule is that there must be a number
in the first position (column A).

Anyway, disregarding the above, think these 2 array formulas should return
the col numbers that you're after

To get First number position (leftmost):
Array-enter* in say, E1:
=MATCH(TRUE,A11<>"",0)
Copy down

To get Last number position (rightmost):
Array-enter* in say, F1:
=MAX((A11<>"")*COLUMN(A11))
Copy down

*Press Ctrl+Shift+Enter to confirm the formula