Thread
:
adv filter
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
Posts: n/a
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
Reply With Quote