Excel List
Hi, Please refer to the attached list.
Column B has users.
Column C has Access rights.
Column G has Access rights that should not be allowed. Without using the macro, can we write some Excel functions, that will help me in listing out those Users who have been given these (not allowed) Access rights.
Thanks.
ValidateList.xlsx
Column B has users.
Column C has Access rights.
Column G has Access rights that should not be allowed. Without using the macro, can we write some Excel functions, that will help me in listing out those Users who have been given these (not allowed) Access rights.
Thanks.
ValidateList.xlsx
Last Comment
ASKER
The solution is partially ok. Maybe I did not explain well. I want to write "Access not allowed" when both of these rights together are allocated to some user. In case a user has one of these rights, then it is fine.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS 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
Bang On. That's what I was looking for. Thanks, that's the good solution.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
=IF(ISNA(MATCH(C4,$G$4:$G$