Excel Advanced Filter the most recent date -

i have data set like:

id  dc1     date 1   sth1    2015-01-01  1   sth2    2016-01-01 1   sth3    2012-01-01 2   sth2    2014-01-01 2   sth3    2012-01-01 

and take recent record each id.

id  dc1     date 1   sth2    2016-01-01 2   sth2    2014-01-01 

is there advanced filter option facilitates or have write function?

you first sort data id , date descending , remove duplicates.
of couse, if need keep data should copy data set new sheet or before doing :)

---

sort

---

remove duplicates

---

result