Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for Most Recent Date | Excel Discussion (Misc queries) | |||
most recent date | Excel Discussion (Misc queries) | |||
keep rows with most recent date | Excel Discussion (Misc queries) | |||
Looking up the most recent date | Excel Worksheet Functions | |||
Find most recent date | Excel Worksheet Functions |