display last value in a column

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

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.
 
Try this...

Assuming there are no logical TRUE entries in the range.

=LOOKUP(1E100,1/B2:B100,B2:B100)
 
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.
Click to expand...


=LOOKUP(2,1/(B:B<>0),B:B)
--ron
 
Back
Top