Forum Discussion
Get most recent Date for each ID
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
=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.
- Thank you- you have just saved me hours of work!
