Vlookup return most recent date (value)
With your data in ColA/B and the query ID in cell C1 try the below
=SUMPRODUCT(MAX(($A$2:$A$100=C1)*$B$2:$B$100))
--
Jacob (MVP - Excel)
"ryanholliday" wrote:
Hello,
I have a set of data where Column A contains an personal ID# (001). Column
B contains a timestamp. My table has multiple entries for each ID# and
different timestamps for each entry. I want to use a vlookup to find the
MOST RECENT timestamp for EACH ID. Any help would be greatly appreciated.
Thanks,
Ryan
|