Find ID from latest entry

[Anonymous]

I have data like this

every Id there is multiple date time and code

 i need the all id's where 30a occurs as the latest date time

30a date time has to be after 12a and 21a date time

hope you can help

[Taoufiq_Zarra]

@Anonymous  can you share a sample data in excel format and the expected output!