View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GregR GregR is offline
external usenet poster
 
Posts: 246
Default 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