Quicker way to Delete Random Product from Sheet?

Hi Folks,

I'm brand spanking new here to this forum and a relatively new to excel.

I'm trying to get a task done at my new job and need some help with this task:

I have an excel sheet with several thousands products.

I also have an excel sheet with hundreds of products that need to be deleted.

The excel sheet with the products to be deleted have a unique product model number to identify with.

I've been using the "Find" feature to query 1 product at a time. It works but it's slow. Is there quicker way to do this?

For example can I feed a list of Product Models to excel and tell it to delete the items?

Thanks,
Aurise

Can you add FILTER in first row and filter what you don't want to delete and delete all other?

I don't know, I'm really novice with excel. I will play around with the menus and see if I can filter something..

Please keep the ideas coming.

Thanks,

Go in first row of your data and then Data -> Filter it will be showen as drop down menu.
Then in column you want to filter your data choose what you need.. there is lot options: less than, starting with, greather then etc.

Zbor,

Thanks for your tips.. I did look into the filter thing but it's just to complicated for me and also the hundreds of products that I have to delete are not in sequential order.

A.

Originally Posted by shg

Assuming the two lists have a common filed, use a MATCH formula in a column in the main list to look for an exact match in the delete list. Then delete the rows where the formula does not return an error

This sounds like it would work but could you explain it a little better?

One of my files is a copy of the Complete Product List (6500 product)

The other file has a list of several hundred product to delete.

They have one field in common: The product Model Number.

--------------------

Shouldn't I use the delete list to look for an exact match in the product list?

A.

best way is to upload an worksheet with examples so someone can fix formula for you.

Originally Posted by zbor

best way is to upload an worksheet with examples so someone can fix formula for you.

Thanks you both for the the help..

Here's samples of the the two files. They are shorten lists but in the same format as the real ones..