Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/duplicat.htm

Dono wrote:

Hi Guys,

I have a situation where a company has had one if its divisions closed
and all of their products need to be removed from the product listing in
Excel.

I need to remove about 150 products from the product listing which has over
2500.

Is there some way to compare the two lists and then delete the products from
the main list.

regards
Paul

--

Dave Peterson