display last value in a column
Try this...
Assuming there are no logical TRUE entries in the range.
=LOOKUP(1E100,1/B2:B100,B2:B100)
--
Biff
Microsoft Excel MVP
"Mike" wrote in message
...
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.
--
Mike
|