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


--

Regards,

Peo Sjoblom


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