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,A1:D1<"",0)
Copy down

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

*Press Ctrl+Shift+Enter to confirm the formula
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"anand" wrote:
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?