Anyone know how to remove certain items excel

so i have a list of zip codes that a customer cant advertise in and i have a list of all the zip codes in the usa is there anyway in excel to filter out on the list all the zip codes they cant advertise in with all the zip codes in the usa to have a big list of good zip codes?

Jonnn said:

so i have a list of zip codes that a customer cant advertise in and i have a list of all the zip codes in the usa is there anyway in excel to filter out on the list all the zip codes they cant advertise in with all the zip codes in the usa to have a big list of good zip codes?

Click to expand...

If you have the list of zip codes that are no good, sort by that and just delete those rows.

This is the simplest method.

https://www.extendoffice.com/docume...olumn-contains-value-form-to-remove-list.html

Yes, definitely... You can use the filter button.
Or rather use the delete button to delete the row and column if possible

There must be several ways to do this. I'm not sure about Excel, but you can do this in Notepad++. Separate the zip codes with the | separator, search for the created string in the text with all the zip codes, bookmark the lines and remove all bookmarked lines.

I made a .gif about the process a while ago, when someone asked something similar: https://www.blackhatworld.com/seo/h...m-2nd-txtfile.821621/#lg=post-8663837&slide=0. (In your example 'new 2' tab would contain the zip codes you want to remove, 'new 1' tab would contain the data with all the zip codes. The only difference is that you want to remove the bookmarked lines at the end.)

Look into Vlookups. Probably the easiest and fastest way in excel. I use this almost every day for various excel tasks.