Compare cells to delete lines?

I have a problem and am wondering if someone knows a fairly simple solution. I create a spreadsheet each month which contains about 20 tabs, each of which has a varying number of lines of the following data. I would like to eliminate rows which only have 2 occurances of the same part number (in red), keeping only those lines which have 3 or more occurances of the same part number. Any help would be appreciated.


8/31/06 K 34 9998 2D8540 SEAL 1
8/31/06 K 34 9998 2D8540 SEAL 2
8/31/06 K 34 9998 2D8540 SEAL 1
8/31/06 K 34 9998 2D8540 SEAL 1
8/31/06 K 34 9998 2H2665 O-RING 1
8/31/06 K 34 9998 2H2665 O-RING 2
8/31/06 K 1 9998 2S-8439 SEAL 1
8/31/06 K 34 9998 2S-8439 O RING 1
8/31/06 K 34 9998 2X464 SWITCH 3
8/31/06 K 34 9998 2X464 SWITCH 2

Looking at each sheet individually. Sorry to confuse the issue. Each sheet is for a different store. I am just trying to establish when a store has ordered the same part 3 or more times in a single month.

Worked great Col. Thanks for helping me impress my boss.

One more favor, only if you have time. Could you kind of explain each step in the macro. I am trying to learn more about macros, and would like to understand what this one is doing

Thanks