adv filter

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

[Ardus Petus]

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

HTH
--
AP

"b166er" <[email protected]> a écrit dans
le message de news: [email protected]...
>
> 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
>