Reverse filter?

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

Hello,

Is there a way to do a "reverse" filter. I'd like to be
able to hide or delete rows that match specified criteria.

Thank you,
Marc
 
Hi Marc,
Unfortunately not, but depending on how you are filtering you
might be able to use
=NOT(oldformula)

For the autofilter you might have to use another column (F)
F1: 'white -- value of cell you don't want to match
F2: =TRIM(F$1)<>TRIM(E2) and fill down
 
If you're talking about an Autofilter you can pick a "custom" filter and
"does not equal" your criteria.
 
With an AutoFilter, you can use the Custom criteria. For example, to
hide rows that are Region: Ontario --

To set up an AutoFilter, select a cell in the table, and choose
Data>Filter>AutoFilter
From the dropdown in the Region heading, select 'Custom'
From the first dropdown, choose 'does not equal'
In the text box, type Ontario, or select it from the dropdown
Click OK
 
Back
Top