troubleshooting Question

filter out users based on permissions

Avatar of Pau Lo
Pau Lo asked on
Microsoft OfficeMicrosoft ExcelVBA
4 Comments2 Solutions45 ViewsLast Modified:
i have received an xlsx file of users and their corresponding security roles for an application. one of the roles is called disabled. If they have that role they cannot access the system. However a user can have many roles, e.g

user 1 - disabled
user 1 - HR read access
user 1 - payroll  read access

what I need is away of filtering the list, to only show users who do not have the disabled role, and just create a filtered list of active accounts and which roles they do have. user name is column A, and the role name is column C. Is there an easy way to acheive this. e.g. if original data was this

user 1 - disabled
user 1 - HR read access
user 1 - payroll  read access
user 2 - HR read access
user 2 - HR admin access
user 3 - disabled
user 3 - HR read access

one filtered would only return

user 2 - HR read access
user 2 - HR admin access

as that is the only user without the disabled role
ASKER CERTIFIED SOLUTION
Shums
Excel VBA Developer
Join our community to see this answer!
Unlock 2 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros