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