W
WildWill
I have A1:A5 which typically fill with data in a sequential manner, i.e.
first A1 would contain a value, then A1 & A2 would contain values, then A1,
A2 & A3 would contain values, etc, etc. I want to look into this range of
cells (A1:A5) and always retrun the "latest" value to cell C1.
E.g. If A1 & A2 have values in them and A3:A5 are empty, then the value of
A2 will be returned to C1. If A1, A2 & A3 have values in them then A3's while
A4 & A5 are empty, then A3's value will be placed in C1, etc, etc.
Thanks!
first A1 would contain a value, then A1 & A2 would contain values, then A1,
A2 & A3 would contain values, etc, etc. I want to look into this range of
cells (A1:A5) and always retrun the "latest" value to cell C1.
E.g. If A1 & A2 have values in them and A3:A5 are empty, then the value of
A2 will be returned to C1. If A1, A2 & A3 have values in them then A3's while
A4 & A5 are empty, then A3's value will be placed in C1, etc, etc.
Thanks!