Hi,
Could someone help with an excel query? I want to find the most recent date for each person and then choose the value two cells over for each ID?
The following does not work as the MAX() range includes a mixture of dates and values:
=HLOOKUP(MAX(A1,E1,I1),A1:L1,2,0)
The database is organised as such:
ID Date1 Value1 Value2 Date2 Value1 Value2 Date3 Value1 Value2........
1
2
3
4
.
.
.
One person (ID) may have two date/value entries and another may have ten so the reference cell (most recent date) will differ for each person, and this will change overtime as more dates/values are entered.
Could someone provide me with a solution to find Value2 for the most recent date for each person?
Kind regards,
Maria