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.