Delete rows based on values in another cell

[jimboc]

Hi Everyone,

I'm working on some data manipulation in Excel but I've gotten stuck. Basically, I'm taking a list of file names and parsing the file names so I have a Part Number and a Revision letter in each column. I wrote a little macro to do that and it's working great.

However, now I need to delete the duplicate part numbers and only keep the latest revision. A sample of the data would be:

Part Number / Revision
12345 A
12345 B
22222 F
22222 L
22222 B
99999 DC
99999 DD

I only want to keep the row that contains the latest revision but I can't figure out how to do it. The rows won't necessarily be in any order but I can sort them by part number and revision if that would help. I've searched all over and have found lots of ways to delete rows where a cell contains a certain value but in this case I need to determine the latest first.

The results I'd like would be
12345 B
22222 L
99999 DD

Can anyone help? Thanks in advance!!

-j