Searching for multiple words or list or names at once

[llmrd]

Hi!

I'm not sure how to phrase that title properly. In one sheet I have a list of about 1000 names. From those 1000, I wanted to delete say about 350 random names.
How do I go about searching for those 350 names at once from the list of 1000 names so I can bulk delete them? Filtering won't help me as I still have to search for the names manually.

excel_names.JPG

[benishiryo]

hi llmrd. if this is an adhoc task, you may use a formula to help you count if it's inside the names to remove. filter it and delete. if this is done regularly, you might want to consider posting this in the programming thread. assuming the names to remove in Sheet2. try this in Sheet1 where Name List is:
=COUNTIF(Sheet2!A:A,A2)

This counts if A2 (Priscilla) appeared in Sheet2 column A. i saw in your screenshot that it has. hence, the formula returns 1. copy the formula down. Filter those with value as 1. Delete all the rows.