Return latest value from data range

  • Thread starter Thread starter WildWill
  • Start date Start date
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!
 
numbers:
=OFFSET(A1,MAX(IF(ISNUMBER(A1:A5),ROW(A1:A5)))-1,)

strings:
=OFFSET(A1,MAX(IF(LEN(A1:A5),ROW(A1:A5)))-1,)

both formulae array-entered i.e. with CTRL+SHIFT+ENTER
 
Back
Top