Identifying the duplicate id names with latest date by formula or VBA

[kismatstha]

Hello experts,

I have 3 columns in the sheet as illustrated below
Column A ->list of ID names
Column B->list of channel numbers corresponding to different ID names
Column C->list of dates corresponding to ID names and the channels numbers

ID channel date
A NEP-IND-12345 2020-05-20
A NEP-IND-12380 2023-09-23
B NEP-IND-23456 2006-01-29
B NEP-IND-23600 2008-08-17
B NEP-IND-23789 2024-01-09



Target: There are duplicate id names in column A and the target is to identify the ID names with latest date. The result should look like below:
ID channel date

A NEP-IND-12380 2023-09-23
B NEP-IND-23789 2024-01-09

SO can you help to give some formulas or macro code to identify the id names for duplicate with latest corresponding date?

Thank you.

-Susan

 

[Special-K99]

Does this work?
Results MUST be in row 2 onwards

in E2 (Array formula)
=IFERROR(INDEX($A$2:$A$10, MATCH(0, COUNTIF($E$1:E1, $A$1:$A$10), 0)),"")

in F2
=AGGREGATE(14,4,(A1:A10=E2)*(C1:C10),1)

in G2
=INDEX($B$1:$B$10,AGGREGATE(14,4,($C$1:$C$10=F2)*($A$1:$A$10=E2)*ROW($B$1:$B$10),1))

 

[kismatstha]

Does this work?
Results MUST be in row 2 onwards

in E2 (Array formula)
=IFERROR(INDEX($A$2:$A$10, MATCH(0, COUNTIF($E$1:E1, $A$1:$A$10), 0)),"")

in F2
=AGGREGATE(14,4,(A1:A10=E2)*(C1:C10),1)

in G2
=INDEX($B$1:$B$10,AGGREGATE(14,4,($C$1:$C$10=F2)*($A$1:$A$10=E2)*ROW($B$1:$B$10),1))

Thank you. works perfectly.