asked on
filter out users based on permissions
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
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
Microsoft OfficeMicrosoft ExcelVBA
Last Comment
Shums Faruk
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
My suggestion is automatic, if you can specify a variety of conditions, if you do not want text containing disabled then choose "does not contain"
No comment has been added to this question in more than 14 days, so it is now classified as abandoned.
I have recommended this question be closed as follows:
Split: Shums (ID: 42070303) and Roy Cox (ID: 42070248)
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.
I have recommended this question be closed as follows:
Split: Shums (ID: 42070303) and Roy Cox (ID: 42070248)
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.