display last value in a column
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 |
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 |
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 |
All times are GMT +1. The time now is 01:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com