Hi there,
I'm trying to create a user look-up tool in excel. My spreadsheet has over 2000 users. ( I've attached a deintified example with 18 users) The problem is that many users work in/ are responsible for multiple locations, and all the locations are bunched in together in one field (in some occasions up to 10 locations).
What I would like is
1. Have custom slicer items in the Slicer as opposed to representing all of the unique values in the column of data
2. Have the Slicer function on the text filtering functionality of "contains".
Is that possible?
Or do I have to do the tedious task and separate all the locations into individual lines
Thanks
MZ
PC, Excel 2013+16
Which column are you trying to filter? What are the locations?
Please give some examples.
The columns I try to filter are P R T V X.
The locations are a hierachy: P - HSDA - a service area (large area); R - Facility - (a specific building); T - Program (department); V - Location type; X - specific location (unit/floor).
e.g. the person in line 4 only has access to 1 service area and 6 facilties that fall under that service area, while the person in line 14 has access to 24 service areas but only to theoretically 1 programs/department (there are 5 listed d/t naming conventions and other technical reasons)
