Remove duplicate rows and keep most recent year

[Trahan-Almighty]

Hi everyone,

When I try to remove remove duplicates row, the highest year is deleted, in this case 2025. I wish that the most recent year is always kept, and the other ones deleted. 

P.S: I already saw similar solved posts with this issue, but I still have trouble finding the right way to resolve this issue. 

Could you please help me?

Many thanks!

Current table

Vendor Number	Year
21400799	2023
21401540	2021
21401224	2022
21400799	2025
21400196	2022
998	2021

Expected result: 

Vendor Number	Year
21401540	2021
21401224	2022
21400799	2025
21400196	2022
998	2021

[syasmin25 · Accepted solution]

Consider using the query editor this way: I grouped the data by specific criteria.