adv filter

B

b166er

hi members,

i want to filter data through adv filter that does not equal to
specific criteria.

i used criteria A1<> JOB335
A2<> JOB339
A3<> JOB350
to show only those jobs which are not equal to that criteria.
but that did not work is there any other way through which i
could give criteria does not equal to specific text or number or
alphanum. keep in mind there are thousands of jobnumbers i have to work
with.
 
A

Ardus Petus

Use a nameless criterion (upper row empty) with formula:
=NOT(OR(A2="JOB335",A2="JOB339",A2="JOB350"))

HTH
 
Top