Forum Discussion
smanas87
Mar 23, 2023Copper Contributor
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
- OliverScheurichGold Contributor
=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.
- ShanD2024Copper ContributorThank you- you have just saved me hours of work!