Most Recent Date and unique name

[GregR]

I have a log file with columns named "Name", "Date", "Amount",
"Vendor". The "Name" col can have multiple entries for the same name. I
want to conditionally format the "Date" col for the most recent entry
for each unique name in the "Name" col. I think I need to add a helper
column with a formula to identify the most recent date for each unique
name. I need help with the formula. TIA

Greg

 

[Tom Ogilvy]

http://www.cpeason.com/excel/duplicat.htm

would be a good place to start.