Lookup earliest and latest dates from repeated parameters

[andrefraga]

I have the below data in spreadsheet one. Observe that the "P6 activity ID repeats" sometimes.
Ps.: the spreadsheet is much longer, the image is just an extract. So there a plenty of others repeated "activities ids".

And I need to collect the earliest start date and latest finish date for this set of "P6 Activity IDs" and bring to this other spreadsheet:
Observe that there.

How do I capture this dates (earliest start and latest finishi) from the set of dates in the first spreadsheet and bring to this second one?

Thanks in advance!

 

[andrefraga]

Anyone, please?

 

[alansidman]

Cannot manipulate data in a picture. Please upload your sample using XL2BB so that we don't have to retype all your data to provide you with a workable solution.