| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FILTER USING MULTIPLE CRITERIA
I am currently using advanced filtering: contains reel *.01* and
does not contain video. I want to filter: contians reel and does not contain video, other, unknown, poker. If I use the * to seperate each criteria it does not work. HELP! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FILTER USING MULTIPLE CRITERIA
Not advanced filtering, custom filtering. Sorry!
"vdefilippo" wrote: I am currently using advanced filtering: contains reel *.01* and does not contain video. I want to filter: contians reel and does not contain video, other, unknown, poker. If I use the * to seperate each criteria it does not work. HELP! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FILTER USING MULTIPLE CRITERIA
for the autofilter, you would need to create a dummy column next to your data
and put in a fomrula like Assume you are checking conditions in column C =AND(COUNTIF(C2,"*reel*")0,SUM(COUNTIF(C2,{"*vide o*","*other*","*unknown*","*poker*"}))=0) then drag fill down the column. filter on True -- Regards, Tom Ogilvy -- Regards, Tom Ogilvy "vdefilippo" wrote: I am currently using advanced filtering: contains reel *.01* and does not contain video. I want to filter: contians reel and does not contain video, other, unknown, poker. If I use the * to seperate each criteria it does not work. HELP! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FILTER USING MULTIPLE CRITERIA
Thanks Tom!
"Tom Ogilvy" wrote: for the autofilter, you would need to create a dummy column next to your data and put in a fomrula like Assume you are checking conditions in column C =AND(COUNTIF(C2,"*reel*")0,SUM(COUNTIF(C2,{"*vide o*","*other*","*unknown*","*poker*"}))=0) then drag fill down the column. filter on True -- Regards, Tom Ogilvy -- Regards, Tom Ogilvy "vdefilippo" wrote: I am currently using advanced filtering: contains reel *.01* and does not contain video. I want to filter: contians reel and does not contain video, other, unknown, poker. If I use the * to seperate each criteria it does not work. HELP! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Multiple Criteria to filter for multiple users | Excel Worksheet Functions | |||
| Filter duplicates by multiple criteria | New Users to Excel | |||
| Filter Multiple Columns on Multiple Criteria and count the last co | Excel Worksheet Functions | |||
| Best Way for Multiple Criteria to Show From a Filter | Excel Discussion (Misc queries) | |||
| Create macro to filter on multiple criteria | Excel Worksheet Functions | |||
Linear Mode
