Maybe this if you want to get rid of the old data and only keep the most
recent data (assuming that your data is sorted as is shown in your sample).

Enter this formula in colun C and copy down to the end of data:

=IF(A3<A2,"x","")

The "x" will mark the latest revision.

Now, convert the formulas to constants:

Select the range of formulas in column C.
Goto EditCopy
Then, EditPaste SpecialValuesOK

Now, sort the entire range on column C in descending order. This will put
all the latest revisions at the top.

Find the last "x" and delete everything after it. Then delete column C.


--
Biff
Microsoft Excel MVP


"Dave" wrote in message
...
I searched the posts, but didn't find anything obvious that would work in
my
situation.

I have a list of part numbers in column A, and their revisions in column
B.
One part number can have 1 or more revisions. I'd like to find the latest
revision for each part number in column A. My list looks like:

PART NUMBER Revision
1120007 A
1120007 B00
5360120 A00
5360120 A01
5360120 D00
and so on

I have 51,000+ rows of data, and would like to summarize by finding only
the
latest revisions of the parts- in this case it would be B00 for PN 1120007
and D00 for PN 5360120. I can probably boil down that 51,000 part number
rows to 3,000 to 4,000.

I sense it would be pretty simple, but I'm a relative novice when it comes
to Excel.

Any help would be greatly appreciated.

Dave