Deleting unwanted data

D

Dono

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
 
M

MartinW

Hi Paul,

How is your data laid out, in a single column or multiple columns?
Is there a unique identifier that you can use Autofilter on? A specific
letter arrangement in the product code or something similar.

Regards
Martin
 
Top