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" wrote in message
...
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