name colour date
alex red 19/01/2015
alex red 15/01/2015
adam green 14/01/2015
adam black 01/01/2015
lucy gold 25/12/2015
jenny red 01/12/2015
jenny blue 01/01/2015
jenny red 17/01/2015
jenny red 17/01/2015

The result should be show in another sheet as below, duplicate name & colour should be show once with the latest date :

name colour date
alex red 19/01/2015
adam green 14/01/2015
adam black 01/01/2015
lucy gold 25/12/2015
jenny blue 01/01/2015
jenny red 17/01/2015

Kindly help provide the code friends. Thanks.