Need Latest dates from Column basis on a condition

[sg2209]

Good Morning Mentors,
Though i have learnt much from the questions I have posted on the foprums and I also see the questions from other users also that is helping me to leanr and grow, i got stuck on one of the issue where I am looking for the latest date with specific condition.
I have below data set ( obviuosly dummy as it's too large ) where for ID IMEA it has 2 transactions one is from 2016 and another is 2023 hence i need date which is 12/6/2023 should copied to column S in corresponding row where I have ID IMEAN not in another row which is blank

Atatched is the format in last column resulsts I am expecting

 

[Chrisdontm]

I think I follow what you want, you could try this;
( It is based on those cells being blank in column "A" where there is no number. )
( it is also based on 100,000 row, change if you need to. )( If you do change the last row reference throughout the formula, notice that the last part is referencing column "K". )

=IFERROR(IF(A1="","",LARGE(OFFSET(A1,0,10,MATCH(INDEX($A2:$A$100000,MATCH(TRUE,INDEX($A2:$A$100000<>"",0,1),0)),$A2:$A$100000,0),1),1)),LARGE($K2:$K$100000,1))

[ paste it into cell " S1 " and copy it on down ]

 

[sg2209]

Sorry for the late response got stuck with some family emergency.
not its not the expected result.