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?

Try this:

=IF(COUNT(A1:D1),MATCH(1E10,A1:D1),"")

--
Biff
Microsoft Excel MVP


"anand" wrote in message
...
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?

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?