Hi,

I have a spreadsheet that contains two columns, hotel and date.

What I wanted to do was only keep the entry that has the latest date, and delete the duplicates.

For example:

Hotel Date
123 1/01/2016
123 2/01/2016
123 3/01/2016
abc 5/01/2016
abc 6/01/2016
abc 7/01/2016

would look like

Hotel Date
123 3/01/2016
abc 7/01/2016

please advise!