Get earliest date from multiple rows and inserting into a column

[Doles_R_714]

Hi Team,

I'm a novice user, and having trouble creating a workflow with dates.

In the sample below, I have two OppIDs. I need to change the values of cells D1:D3 with the earliest date in column C for the OppID 12349020. In this case, the earliest date in column C is "5/31/2024".

I need to do the same with the second Opp ID. I need to change the values of cells D6:D8 with the earliest date in column C for Opp ID 33765. In this case, the earliest date in column C is "4/31/2024".

	OppID	Column B	Column C	Column D
1	12349020	11	11/22/2024	11/22/2024
2	12349020	12	11/22/2024	11/22/2024
3	12349020	13	11/22/2024	11/22/2024
4	12349020	14	5/31/2024	5/31/2024
5	337765	56	4/31/2024	4/31/2024
6	337765	80	11/22/2024	11/22/2024
7	337765	45	11/22/2024	11/22/2024
8	337765	48	11/22/2024	11/22/2024

so my expected output would look like this:

	OppID	Column B	Column C	Column D
1	12349020	11	11/22/2024	5/31/2024
2	12349020	12	11/22/2024	5/31/2024
3	12349020	13	11/22/2024	5/31/2024
4	12349020	14	5/31/2024	5/31/2024
5	337765	56	4/31/2024	4/31/2024
6	337765	80	11/22/2024	4/31/2024
7	337765	45	11/22/2024	4/31/2024
8	337765	48	11/22/2024	4/31/2024

Thank you in advance for your help. 

[KGT · Accepted solution]

Firstly change your date columns to actual dates in YYYY-MM-DD format with a date type.

Then a summarise on OppID with Min_ColumnC.

Join that back on and make it your column D

[Doles_R_714]

This worked! Thank you so much for the guidance and the quick reply.