Hi, i am working on a project right now and need some help. To describe my problem I have horizontal list in excel with items which are user roles. Then I have a vertical list with the names of the each user. Under the horizontal list I have X matching the users each userroles based on an extract. Then also have a cell where I gather all the X's for each individual user and then also have another cell where I want to have a formula to check wether there is a conflict between the user roles. Because the idea is that a user can have multiple userroles attributed to him/her but some of these roles are conflicting with eachother and do not go together. Asuming you yourself decide which ones are allowed together which ones are not, how could you arrange this? How do I make this cell formula knowing which roles can not be together(i.e the X's). Also notice if one only 1 of the "X's" conflicts with another x then the entire Range of X's is a conlict and this should be highlighted in the "user right check cell" with a formula. This is the part where I need most help with.
Please feel free to ask questions If it is not clear and for additional information. Thanks in advance!
Please feel free to ask questions If it is not clear and for additional information. Thanks in advance!