[Google Sheets] Get uniques IDs based on latest date

[rolito]

Hello, I have a googe sheet with these columns:

DATE- ID - PRODUCT- PRICE

See attached example file

I just need a google sheet function to remove duplicates but keep IDs with latest date ocurrence

Thanks in advance!

[Haluk]

Why don't you give a link to your shared document ?

.

[rolito]

I tried to link my Google Sheet, buy ExcelForum doesn´t allow me to publish links!

[Bo_Ry]

Please try

=INDEX(VLOOKUP(unique(filter(B2:B,B2:B>0)),{index(SORT(A2:D,1,0),,2),SORT(A2:D,1,0)},SEQUENCE(1,4,2),0))