Get most recent Date for each ID

[smanas87]

ID	Start Date
1	03/12/2022
1	01/02/2023
2	01/20/2021
3	05/04/2019
3	09/01/2022

Please advise a formula to get the most recent date for each ID. Thank you

[#2]

@smanas87 

=LARGE(IF($A$2:$A$6=A2,$B$2:$B$6),1)

You can try this formula if the data is in range A2:B6. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021. The formula is in cell C2 and filled down to cell C6.

[#3]

@smanas87 If you are on Microsoft-365 then could try the following spill formula.

=HSTACK(UNIQUE(A2:A6),MAP(UNIQUE(A2:A6),LAMBDA(x,MAXIFS(B2:B6,A2:A6,x))))

[#4]

@smanas87 

Another option is to create PivotTable

[#5]

Thank you- you have just saved me hours of work!