Display the latest figure in a column??

Hi there,

I need a formula that will display the latest figure in a column.

I have attached an image as an example of what I mean.

In the example attached I would like the bottom cell to display the latest which would be 40.

Is this possible?

Thanks

Mark

The fact that you have 0's in your column makes it a little trickier (for me) but if there is never a day when you receive 0 emails, the following will work;

Please Login or Register  to view this content.

Where C5:C11 is your range

Does this work for you?

ChemistB

That was exactly what I was looking for!!

Many thanks for both of your help!!

You could also try

=LOOKUP(2,1/(B2:B6>0),B2:B6)