I HAVE AN EXCEL WORKSHEET WHICH IS SOMEWHAT LIKE THE FOLLOWING;

Item ID Date Quantity
123 01-Aug 12
123 03-Aug 4
123 03-Aug 343
123 03-Mar 4
123 05-Aug 454
124 07-Aug 5
124 08-Aug 65
125 01-Aug 3
125 05-Aug 4
125 09-Aug 2

I WANT NOW TO CREATE A REPORT IN WHICH EACH OF THE ABOVE ITEM APPEAR JUST ONCE, AND THE APPEARING ONE SHOULD BE THAT ONE WHICH HAS THE LATEST DATE WITHIN AN ITEM I.E.

Item ID Date Quantity
123 05-Aug 454
124 08-Aug 65
125 09-Aug 2.

LIKE ITEM NO. 123 WAS ISSUED 5 TIMES AND THE VERY LATEST IT WAS ISSUED WAS ON 05-AUG AND SO THAT RECORD IS APPEARING ON THE ABOVE REPORT.

I HOPE I AM ABLE TO EXPLAIN MY REQUIREMENT, IF NOT PLEASE LET ME