Ask Your Question

Filtering a spreadsheet based on a "blacklist"?

asked 2019-06-22 18:33:22 +0200

evertiro gravatar image

I have two files, one being a spreadsheet of user data, the other being a single-column list of email addresses. On the actual data sheet, email addresses are in column "D". I need to find a way to remove all entries in the spreadsheet that have an email that exists in the blacklist. Can anyone provide direction on that one?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-06-22 18:55:54 +0200

Lupp gravatar image

Use a helper column to find the rows containing blacklisted data, use the Autofilter tool, copy the data remaining (rows filtered out will automatically not be copied), and paste the into the new place.

See this demo.

edit flag offensive delete link more


That's perfect! I had the Autofilter part figured out, but couldn't get the formula. That did exactly what I needed, thanks!

evertiro gravatar imageevertiro ( 2019-06-22 21:49:17 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-06-22 18:33:22 +0200

Seen: 62 times

Last updated: Jun 22 '19