Vlookup for minimum or maximum date

[johnnykoung]

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

[NickSm · Accepted solution]

@johnnykoung 

Summarize tool actually works really well for this. Just have to have the dates in the recognized date format of yyyy-MM-dd

[johnnykoung]

That's perfect, thank you! Didn't realize the summarize function had those options.