Summarizing Data

[Jack]

I have a spreadsheet that contains data for over 8000
different part numbers and their order history. I am only
interested in the latest receipt date for each part number
but the sheet displays multiple entries for each part
number. Is there a way that I can get excel to summarize
the data so that it only displays the last receipt for
each part number. They are already sorted by part number
and receipt date, so its just a case of getting the last
record for each only to display. I would be very grateful
if anyone could help me with this one.

 

[Frank Kabel]

Hi
one way:
- use a pivot table
- as row item use your part number
- as data item use Max of date