Most Recent Date and unique name
 

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

Most Recent Date and unique name
 

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

would be a good place to start.

--
Regards,
Tom Ogilvy


"GregR" wrote in message
oups.com...
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