Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I use multiple "Does not contain" function in excel?
When using the autofilter you can use the custome filter and use the "does
not contain" criteria. However, I have multiple data I wish to not include so I use the advance filter but I don't know how. |
#2
|
|||
|
|||
if you set up a dummy column next to the one of interest, you can use if
stements to set up a yes or know criteria for what you want to include and filter on thatr column with auto filter for the advanced filter, My best suggestion is to read the help on it or other books on it and play with it some. It is not really a response level description on how to use it. One of the other responders may have some good website recommendations? "Raph_baril" wrote: When using the autofilter you can use the custome filter and use the "does not contain" criteria. However, I have multiple data I wish to not include so I use the advance filter but I don't know how. |
#3
|
|||
|
|||
You could use this for your criteria for an adv. filter:
=ISERROR(SEARCH("apple",A2))*ISERROR(SEARCH("orang e",A2)) where you want to exclude anything in col. A containing "orange" and "apple." To learn more, see: http://www.contextures.com/xladvfilter01.html HTH Jason Atlanta, GA "Raph_baril" wrote: When using the autofilter you can use the custome filter and use the "does not contain" criteria. However, I have multiple data I wish to not include so I use the advance filter but I don't know how. |
#4
|
|||
|
|||
My add-in EasyFilter have 5 options if you filter on one column
Maybe OK for you http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Raph_baril" wrote in message ... When using the autofilter you can use the custome filter and use the "does not contain" criteria. However, I have multiple data I wish to not include so I use the advance filter but I don't know how. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Sum Indirect function through multiple sheets | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
how do i reference multiple rows/columns with one function? | New Users to Excel | |||
SumIf Function using multiple criteria | Excel Worksheet Functions |