Thread
:
In a column of numbers, how do I return the last non-zero number?
View Single Post
#
2
Posted to microsoft.public.excel.misc
Biff
Posts: n/a
In a column of numbers, how do I return the last non-zero number?
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?
Reply With Quote
In a column of numbers, how do I return the last non-zero number?