Open the Advanced Filter window using the steps described above. The List range: and the Criteria range: will remain the same. Change Copy to: to reflect the new location of the filtered data. See the ...

To find blank cells using an Advanced Filter, use a single equal sign as your criteria expression. Let’s look at a quick example using the same setup from a few weeks ago.