Peo...you were correct...had to do with me not entering the ctrl, shift &
enter but I went back and tried again and it works perfectly...thanks!

"Peo Sjoblom" wrote:

It works believe me, so either you didn't apply it correctly or your data is
not what it
is supposed to be.

Post the exact formula you tried, copied from your workbook

--


Regards,


Peo Sjoblom

"Daveo" wrote in message
...
Peo,

I tried your formula and I got back #VALUE!...any other suggestions?


"Peo Sjoblom" wrote:

=INDEX(A1:X1,MATCH(TRUE,A1:X1<0,0))

entered with ctrl + shift & enter

--


Regards,


Peo Sjoblom

"Daveo" wrote in message
...
I have a row of data with either zeros or numbers in 24 cells. I would
like
to create a formula in an adjacent cell which scans the 24 cells and
records
the first nonzero number it finds.

I've thought of using a nested if-then but that seems to cumbersome.
Would
appreciate your feedback...thx.

Daveo