| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering for more than 2+ "does contain" criteria
I have worked with the Advanced Filter for a few days and don't believe I can
get the result I am looking for. From the example I gave, I would like to see a list of customers that have both a homeowners and automobile policy with us. This requires the filter to first look at the customer column and see JSmith has a AUT and a HOM so this would be included in the list. YKell would not pass throught the filter since this customer has only a AUT policy. Lynne |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Quick question about "filtering" macro | Excel Discussion (Misc queries) | |||
| VBA to address first visible cell in Column "D" after filtering | Excel Discussion (Misc queries) | |||
| 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 | |||
Threaded Mode
