Screencap:

http://img519.imageshack.us/img519/1...nonzero6xy.jpg

Biff

"CLR" wrote in message
...
That seems to return only the value in A10.........

Perhaps this........
=SMALL(A1:A10,COUNTIF(A1:A10,0)+1)

Vaya con Dios,
Chuck, CABGx3





"Biff" wrote:

Hi!

In a column of numbers

Try this:

=LOOKUP(2,1/(A1:A10<0),A1:A10)

Biff

"ACEACE" wrote in message
...
That is the bottom-most non-zero number?