I have a spreadsheet that is sorted by an item number and the date. I need to only show or extract the most recent date for that particular item number. It would have been simple, but there is one field that I need that is different for each record.

Example:

Item # Date Item Name PO # PO Rel #

12345 11/01/06 clamp 22222 8
12345 10/25/06 clamp 22222 5
12345 10/10/06 clamp 22222 7

12366 11/08/06 syringe 34567 5
12366 11/02/06 syringe 34567 8


By this example I already have it sorted by date and item #. I only want to show the last date for item 12345 and then the last date for item 12366, which would be the first record for each etc. I tried subtotals and then grouping and levels, but I cannot isolate the record that I need for each group.

Any help is appreciated.

Thank you.