Forum Discussion

smanas87's avatar
smanas87
Copper Contributor
Mar 23, 2023

Get most recent Date for each ID

IDStart Date
103/12/2022
101/02/2023
201/20/2021
305/04/2019
309/01/2022

 

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

  • 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.

    • ShanD2024's avatar
      ShanD2024
      Copper Contributor
      Thank you- you have just saved me hours of work!
  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor

    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))))

     

     

Resources