Hi,
I have a set of data with an ID and a start date and end date. It looks like this:
ID Start Date End Date
1 7/1/2019 12/31/2019
1 8/1/2019 11/29/2019
2 2/1/2019 5/1/2019
2 3/1/2019 6/1/2019
If I just get a unique list of IDs (in this case the list would be 1,2), how could I join/vlookup the minimum start date for that ID and the maximum end date for that ID? The end result should come out to
ID Start Date End Date
1 7/1/2019 12/31/2019
2 2/1/2019 6/1/2019
Thanks,
Johnny
Solved! Go to Solution.
Summarize tool actually works really well for this. Just have to have the dates in the recognized date format of yyyy-MM-dd
That's perfect, thank you! Didn't realize the summarize function had those options.