Removing Duplicates on excel sheet

I am currently working on a spreadsheet w/ 20,000 lines. Each line has a unique SKU number. Of those 20,000 unique SKU's I will have roughly 280 changes to them. I plan on pasting the changed sku's at the bottom and marking them with the letter "C" in a seperate column. Once that is done I can sort them by SKU and have the changed SKU line up next to the original SKU

The issue I having is removing the duplicates. I know 2007 has the remove duplicates feature, but when I have used in the past it didn't remove the old SKU.

Any thoughts?

I assume you are using 2003.

You can use: Data> Filter> Advance Filter

This can help you find duplicate values, then if you are trying to find which rows have 2 different SKU's you can find them (assuming that they are in different columns).

=if($B2=$C2, "Original", "Changed SKU")

Actually using 2007, but I would think that would still work.. Let me try it out.

Below is an example: The SKU itself is not being removed, but the actual data after the SKU is changing (I.E. Price, Products Data, etc.

Change Code SKU

C 1091487
1091487 (Original SKU)
C 1115864
1115864 (Original SKU)
C 1142736
1142736 (Original SKU)