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.
 
B

Bob Phillips

See response in .excel

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
Top