advanced filter

  • Thread starter Thread starter carl
  • Start date Start date
C

carl

hi.

is it possible to set the criteria to "not equal" and "not
contain" selected criteria ?

thank you in advance.
 
To combine those criteria, use a formula in the criteria area, and leave
the heading cell blank. For example, if the data you're filtering is in
column D, starting in row 2:

=AND(D2<>"Desk",ISERROR(SEARCH("Pen",D2,1)))

To use "not equal" alone, use the same heading in the criteria area that
is in the table column, and the not equal operator:

ITEM
<>Desk

To use only "not contain", leave the heading cell blank, and a formula
similar to the following:

=ISERROR(SEARCH("Pen",D2,1)
 
Back
Top