The Advanced Filter window will look the same as it did in the third example except for List range:. Instead of clicking in a blank cell for List range:, select the cell or range of cells that contain ...

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.