Date corresponding to last value

[hhenrion]

Hi experts,

In range A1:A100 I have dates
In range B1:B100 I have values (a lot of them are zeros).
In range C1:C100 I have values (a lot of them are zeros).
In range D1:D100 I have values (a lot of them are zeros).

I try to get in cell B102 the date corresponding to the last non-zero value in range B1:B100 ...
Same for cell C102 with range C1:C100.
Same for D
...

Can you help ?

Thanks in advance,
Rgds,

H.

 

[Krishnakumar]

This should work.

=LOOKUP(2,1/(B1:B6<>0),A1:A6)

 

[Richard Schollar]

PGC - My apologies, you are absolutely correct. Using the balance on my bank account in place is definitely best Oh I so wish!

Kris - Like that replacement.


Richard