adv filter
 

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.


--
b166er
------------------------------------------------------------------------
b166er's Profile: http://www.excelforum.com/member.php...o&userid=34912
View this thread: http://www.excelforum.com/showthread...hreadid=552897

adv filter
 

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

HTH
--
AP

"b166er" a écrit dans
le message de news: ...

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.


--
b166er
------------------------------------------------------------------------
b166er's Profile:
http://www.excelforum.com/member.php...o&userid=34912
View this thread: http://www.excelforum.com/showthread...hreadid=552897