On 18/10/05 6:53 AM, in article ,
"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


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