Return Latest Date from a range of data

Dear Admin,

I got a problem that I always need to do a donkey work that to sort out the latest date from my supplier list, For Example:

Supplier Date
123 1/1/10
125 1/1/10
126 1/1/10
123 2/1/10
125 2/1/10
126 2/1/10

The result should be return :

Supplier Date
123 2/1/10
125 2/1/10
126 2/1/10

With this I no need to check day by day , date by date, do sorting and count manually for thosand lines.
Is it possible to work around a coding to perform this action ? or using some excel formula ?? Thanks and Regards