Forum Discussion
Is Advanced Filter the Answer in Excel?
Let's say the column with zip codes in your data has header ZIP.
Make sure that your list of zip codes to be excluded has exactly the same header.
Click anywhere in the data.
Click Advanced.
The List range should be correct.
Click in the Criteria range box.
Switch to the other sheet.
Select the list of zip codes to be excluded, including the header row.
Make sure that Filter the list, in-place is selected.
Click OK.
Select the entire filtered range, and copy/paste it to where you want it.
Switch back to the data sheet.
Delete all rows except the header row.
Click Clear (above Advanced) to remove the filter.
Let's say the column with zip codes in your data has header ZIP.
Make sure that your list of zip codes to be excluded has exactly the same header.
Click anywhere in the data.
Click Advanced.
The List range should be correct.
Click in the Criteria range box.
Switch to the other sheet.
Select the list of zip codes to be excluded, including the header row.
Make sure that Filter the list, in-place is selected.
Click OK.
Select the entire filtered range, and copy/paste it to where you want it.
Switch back to the data sheet.
Delete all rows except the header row.
Click Clear (above Advanced) to remove the filter.
WOW! Thank you. It worked after I figured out the List Range did not pick up the column headers.
