View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default Vlookup return most recent date (value)

This is an ARRAY formula that must be entered/edited using ctrl+shift+enter

=MIN(IF(a6:a66="a",B6:B66))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ryanholliday" wrote in message
...
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