Log In
Register
Home
New Member
March 6, 2021
Offline
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
VIP
Trusted Members
June 25, 2016
Offline
Which column are you trying to filter? What are the locations?
Please give some examples.
New Member
March 6, 2021
Offline
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)
1 Guest(s)
