Link to home
Start Free TrialLog in
Avatar of kwarden13
kwarden13

asked on

Excel Slicer Contains vs Filter

Hi Everyone-

I need some help developing a workaround to have a custom list as a slicer and then filter anything containing the selection. Is this possible? See workbook attached.
Slicer-Example.xlsx
Avatar of Professor J
Professor J

from what i understood you want to be able to select multiple regions in Region Slicer.
to do that, simply hold your keyboard Control Key and then select one by one the regions you want the selection done.
remember clicking twice will deselect it while Control key is pressed.
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kwarden13

ASKER

If you open the workbook, the region slicer is not clean. I want it to show East, West, North, and South. Currently, it is not clean. I am trying to figure out a way to display a clean region and when selected show any items containing that region.

Make sense?
I offered the search box and they do not want it.
Then you would need to add another helper column to split regions. Please refer below link:
Excel Slicer Comma Separated Values
Hi Shums - I was trying to figure out how that would look with the data. I am assuming it would add rows. For example, if there were 3 regions, there would be 2 additional rows (original +2)
if your data is like this , how would you get South when no single value has South. it has South East not "South"

East, West, North
South, East
North, West
North
South, East
East
North
Thats what I am trying to figure out. Right now users can select multiple regions creating entries like south, east. when they filter i need them to be able to pull up any records containing their selection. For example, if you filter on North you should see the following records displayed in the pivot table:

East, West, North
North, West
North
North
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
No comment has been added to this question in more than 14 days, so it is now classified as abandoned.

If you feel this question should be closed differently, post an objection and a moderator will read all objections and then close it as they feel fit. If no one objects, this question will be closed automatically the way described above.