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.

When applied, the MATCH function searches for items in a range of cells based on any given criteria. When found, the function will direct you to any cells that fit the criteria given. This article ...