Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter on multiple criteria, same cell
I'm using code linked from this forum (I can't remember exactly the website,
but the filename I got was DataValMultiSelect.xls) I can get it to return the user selection to the offset cell, no problem. I have changed the delimiter to ; What I want to be able to do however is run a filter based on ANY of the terms selected, rather than ALL of the terms. Example: Drop Down 1 has the values: John, Jack, Steve, Bill, Tom, Jason Selecting John, Steve and Jason places: John;Steve;Jason in the offset cell These values are found on multiple occasions in column 1 of the data source. Drop Down 2 has the values: Julie, Sally, Kate, Kylie, Nancy, Kathy Selecting Sally, Kate & Kathy places: Sally;Kate;Kathy in the offset cell These values are found on multiple occasions in column 2 of the data source. When I run the filter, I want to be able to find all records that have John, Steve OR Jason in the first column AND Sally, Kate or Kathy in the second. Any ideas? |
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 | |||
Multiple Filter Criteria in Excel VBA | Excel Programming | |||
FILTER USING MULTIPLE CRITERIA | Excel Programming |