display last value in a column
On Sat, 5 Dec 2009 20:03:01 -0800, Mike wrote:
I would like to display the last value unequal to zero recorded in a column
in a specific cell. For example, A1 is to display the last value unequal to
zero recorded in column B. The number of entries and values in column B
changes frequently; therefore the last value in column B is in a different
row.
Thanks.
=LOOKUP(2,1/(B:B<0),B:B)
--ron
|