Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
advanced filters
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 |
#3
|
|||
|
|||
advanced filters
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 |
#4
|
|||
|
|||
advanced filters
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 |
#5
|
|||
|
|||
advanced filters
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help: Multiple filters with mutually exclusive items | Excel Discussion (Misc queries) | |||
Req: How to create multiple mutually exclusive filters | Excel Worksheet Functions | |||
Advanced Filters | Excel Worksheet Functions | |||
filters logics | Excel Worksheet Functions | |||
advanced filter criteria "begins with" and "does not begin with" | Excel Worksheet Functions |