Dear All

Kindly i need your support. I have a list of sites with dates. Some sites are repeated with different dates, i want to deduct sites with their latest dates if they are repeated. Thanks.

Input:

Date Site ID
10-Nov-15 100
10-Nov-15 100
10-Nov-15 100
20-Nov-16 100
20-Nov-16 100
20-Nov-16 100
25-Nov-16 105
25-Nov-16 105
25-Nov-16 105
6-May-16 375
6-May-16 375
6-May-16 375
2-Feb-15 490
2-Feb-15 490
2-Feb-15 490
2-Jan-17 105
2-Jan-17 105
2-Jan-17 105



Output

Date Site ID
20-Nov-16 100
20-Nov-16 100
20-Nov-16 100
6-May-16 375
6-May-16 375
6-May-16 375
2-Feb-15 490
2-Feb-15 490
2-Feb-15 490
2-Jan-17 105
2-Jan-17 105
2-Jan-17 105