I posted this in the Macros forum also, but thought it might be more appropriate here.

We work with price files that are up to 300,000 rows or more. We need to find the rows that are duplicate part #'s (easy), but then we need to delete everything that's NOT a duplicate. Deleting duplicates simple, deleting non-duplicates, not as simple.

Can someone help us come up with a way to do this?

Thanks,
E-