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