advanced filters

is it possible to use an advanced filter to find data that does not match a
condition?

for example, i have a file i need to filter that has one column that can
have a value of "k" or be empty. The filter easily finds those records that
have "k" in column c. How would i find those records that dont have a "k"
in them?

tia

peter

You can set up a Criteria range, say, in F1:F2 with F1 left empty and F2
housing:

=ISERR(SEARCH("k",C2))


jiwolf wrote:
> is it possible to use an advanced filter to find data that does not match a
> condition?
>
> for example, i have a file i need to filter that has one column that can
> have a value of "k" or be empty. The filter easily finds those records that
> have "k" in column c. How would i find those records that dont have a "k"
> in them?
>
> tia
>
> peter
>
>

Or use a label in F1 and criteria <>k in F2


--

Regards,

Peo Sjoblom


"Aladin Akyurek" <[email protected]> wrote in message
news:[email protected]...
> You can set up a Criteria range, say, in F1:F2 with F1 left empty and F2
> housing:
>
> =ISERR(SEARCH("k",C2))
>
>
> jiwolf wrote:
> > is it possible to use an advanced filter to find data that does not
match a
> > condition?
> >
> > for example, i have a file i need to filter that has one column that can
> > have a value of "k" or be empty. The filter easily finds those records
that
> > have "k" in column c. How would i find those records that dont have a
"k"
> > in them?
> >
> > tia
> >
> > peter
> >
> >

Not sure you even need to use advanced filter, Auto Filter should do it if,
in the dropdown, you select Custom> Does not contain> k

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"jiwolf" <[email protected]> wrote in message
news:[email protected]...
> is it possible to use an advanced filter to find data that does not match
> a condition?
>
> for example, i have a file i need to filter that has one column that can
> have a value of "k" or be empty. The filter easily finds those records
> that have "k" in column c. How would i find those records that dont have
> a "k" in them?
>
> tia
>
> peter
>

On 18/10/05 6:53 AM, in article [email protected],
"jiwolf" <[email protected]> wrote:

> is it possible to use an advanced filter to find data that does not match a
> condition?
>
> for example, i have a file i need to filter that has one column that can
> have a value of "k" or be empty. The filter easily finds those records that
> have "k" in column c. How would i find those records that dont have a "k"
> in them?
>
> tia
>
> peter
>
>
You don't need the advanced filter just the auto filter
In the drop down filter, select custom filter, in the 1st box select does
not equal, box to right type or select k from drop down.
Paul