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