Filters are great tools, but you can't remove specific items from the results. When you need to do this, try Find All in Excel instead.

Learn the criteria expression for finding blank cells using Excel's Advanced Filter feature. A few weeks ago, I showed you how to use And and Or operators with Excel’s Advanced Filter feature.