Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Latest date from multiple list
Problem
Column "A" "B" "C" List of names, unique identifiers date. Over 7000 rows. The name, unique id may be listed once or multiple, unknown multiples. What I need is the latest date of all of multiples in column D. Or if another way to extract all of the Unique identifiers with the latest date. Thanks so much for you help. Lomax |
#2
|
|||
|
|||
Got it..
Used a pivot with the date in the data area and set to max. Copy paste and use the vlookup back to the unique listing. Got to go around the world to get to my elbow but we are here. thanks lomax "Lomax" wrote in message news:ICB7e.30$gV.29@lakeread02... Problem Column "A" "B" "C" List of names, unique identifiers date. Over 7000 rows. The name, unique id may be listed once or multiple, unknown multiples. What I need is the latest date of all of multiples in column D. Or if another way to extract all of the Unique identifiers with the latest date. Thanks so much for you help. Lomax |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return the latest date from a list of dates | Excel Worksheet Functions | |||
Last Date in List | Excel Discussion (Misc queries) | |||
drop down list multiple columns | Excel Discussion (Misc queries) | |||
How can I sum information in a list with a date range? | Excel Worksheet Functions | |||
Single list from multiple sheets | Excel Worksheet Functions |