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