adv filter

  • Thread starter Thread starter b166er
  • Start date Start date
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.
 
Use a nameless criterion (upper row empty) with formula:
=NOT(OR(A2="JOB335",A2="JOB339",A2="JOB350"))

HTH
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adv filter 3
Advanced Filter Question 14
Does Not Equal 2
Adv Filter on date range 2
Nest SumIf 3
Data Base Functions 2
Sumproduct excluding multiple criteria 8
remembering the same filtering criteria 13

Back
Top