Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter "Not Equal"
When applying multiple < criteria in advanced filter it does not work! Why?
A1 <*bus* <*Inde* <*schoo* Why don't the "Or" statements work? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter "Not Equal"
You probably need an AND, not an OR, if you're trying to exclude all
three of these strings. For an AND, add the heading cell to the criteria range three times, and put all three criteria on the same row. Run the advanced filter again, and adjust the criteria range. Pat Flynn wrote: When applying multiple < criteria in advanced filter it does not work! Why? A1 <*bus* <*Inde* <*schoo* Why don't the "Or" statements work? Thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter "Not Equal"
Thanks Debthat makes sensebut why do the or statements work e.g.
A1 *bus* *scho* *indep* Thanks again for the help "Debra Dalgleish" wrote: You probably need an AND, not an OR, if you're trying to exclude all three of these strings. For an AND, add the heading cell to the criteria range three times, and put all three criteria on the same row. Run the advanced filter again, and adjust the criteria range. Pat Flynn wrote: When applying multiple < criteria in advanced filter it does not work! Why? A1 <*bus* <*Inde* <*schoo* Why don't the "Or" statements work? Thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter "Not Equal"
With the sample data:
bus school house Testing the data against your criteria: Is "bus" equal to *bus* OR *scho* OR *indep* -- TRUE Is "scho" equal to *bus* OR *scho* OR *indep* -- TRUE Is "house" equal to *bus* OR *scho* OR *indep* -- FALSE Since you used the OR operator, and "bus" meets at least one of the criteria, it passes through the filter. When you add the < (does not equal) operator: Is "bus" not equal to *bus* -- FALSE OR not equal to *scho* -- TRUE OR not equal to *indep* -- TRUE Since you used the OR operator, and "bus" meets at least one of the criteria, it passes through the filter. If you use the AND operator, "bus" must meet all the criteria, and not equal any of the items in the list. It doesn't meet all the criteria, so would not pass through the filter. Pat Flynn wrote: Thanks Debthat makes sensebut why do the or statements work e.g. A1 *bus* *scho* *indep* Thanks again for the help "Debra Dalgleish" wrote: You probably need an AND, not an OR, if you're trying to exclude all three of these strings. For an AND, add the heading cell to the criteria range three times, and put all three criteria on the same row. Run the advanced filter again, and adjust the criteria range. Pat Flynn wrote: When applying multiple < criteria in advanced filter it does not work! Why? A1 <*bus* <*Inde* <*schoo* Why don't the "Or" statements work? Thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter "Not Equal"
gracias por sus explinacion a mi amiga!
"Debra Dalgleish" wrote: With the sample data: bus school house Testing the data against your criteria: Is "bus" equal to *bus* OR *scho* OR *indep* -- TRUE Is "scho" equal to *bus* OR *scho* OR *indep* -- TRUE Is "house" equal to *bus* OR *scho* OR *indep* -- FALSE Since you used the OR operator, and "bus" meets at least one of the criteria, it passes through the filter. When you add the < (does not equal) operator: Is "bus" not equal to *bus* -- FALSE OR not equal to *scho* -- TRUE OR not equal to *indep* -- TRUE Since you used the OR operator, and "bus" meets at least one of the criteria, it passes through the filter. If you use the AND operator, "bus" must meet all the criteria, and not equal any of the items in the list. It doesn't meet all the criteria, so would not pass through the filter. Pat Flynn wrote: Thanks Debthat makes sensebut why do the or statements work e.g. A1 *bus* *scho* *indep* Thanks again for the help "Debra Dalgleish" wrote: You probably need an AND, not an OR, if you're trying to exclude all three of these strings. For an AND, add the heading cell to the criteria range three times, and put all three criteria on the same row. Run the advanced filter again, and adjust the criteria range. Pat Flynn wrote: When applying multiple < criteria in advanced filter it does not work! Why? A1 <*bus* <*Inde* <*schoo* Why don't the "Or" statements work? Thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Live" Advanced Filter (for unique records) | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Advanced filter formula for "contains="Sept" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |