Excel Advice - Finding prohibited combinations of permissions among employees

%3CLINGO-SUB%20id%3D%22lingo-sub-2280781%22%20slang%3D%22en-US%22%3EExcel%20Advice%20-%20Finding%20prohibited%20combinations%20of%20permissions%20among%20employees%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280781%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20the%20attached%20table%2C%20I%20need%20to%20find%20employees%20(with%20the%20same%20name)%20who%20have%20the%20following%20prohibited%20combinations%20of%20permissions%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22Credit%20Memo%22%20%2B%20%22Customers%22%3CBR%20%2F%3E%22Create%20Vendor%20Bills%22%20%2B%20%22Vendors%22%3CBR%20%2F%3E%22Make%20Journal%20Entry%22%20%2B%20%22Journal%20Approval%22%3CBR%20%2F%3E%22Check%22%20%2B%20%22Vendors%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20other%20words%2C%20I%20need%20to%20filter%20the%20table%20by%20employees%20and%20see%20if%20each%20employee%20has%20one%20of%20four%20(or%20all%20four)%20prohibited%20combinations%20in%20the%20field%20%22Permission.%22%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20hoping%20to%20see%20something%20like%20that%20or%20similar%20in%20the%20final%20report%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22416%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22241.6px%22%3EProhibited%20Combinations%3A%3C%2FTD%3E%3CTD%20width%3D%2285.6px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2288px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22241.6px%22%3E%22Credit%20Memo%22%20%2B%20%22Customers%22%3C%2FTD%3E%3CTD%20width%3D%2285.6px%22%3EA%20Wolfe%3C%2FTD%3E%3CTD%20width%3D%2288px%22%3EEdgar%26nbsp%3B%20Manas%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22241.6px%22%3E%22Create%20Vendor%20Bills%22%20%2B%20%22Vendors%22%3C%2FTD%3E%3CTD%20width%3D%2285.6px%22%3EA%20Wolfe%3C%2FTD%3E%3CTD%20width%3D%2288px%22%3EHasan%20Yorukoglu%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22241.6px%22%3E%22Make%20Journal%20Entry%22%20%2B%20%22Journal%20Approval%22%3C%2FTD%3E%3CTD%20width%3D%2285.6px%22%3EXimena%20Colla%3C%2FTD%3E%3CTD%20width%3D%2288px%22%3EEdgar%26nbsp%3B%20Manas%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22241.6px%22%3E%22Check%22%20%2B%20%22Vendors%22%3C%2FTD%3E%3CTD%20width%3D%2285.6px%22%3EHasan%20Yorukoglu%3C%2FTD%3E%3CTD%20width%3D%2288px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20please%20give%20me%20an%20advise%3F%20(field%20%22Level%22%20is%20ignored%20for%20this%20task)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20appreciate%20any%20help.%20Thank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2280781%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hello guys,

 

From the attached table, I need to find employees (with the same name) who have the following prohibited combinations of permissions:

 

"Credit Memo" + "Customers"
"Create Vendor Bills" + "Vendors"
"Make Journal Entry" + "Journal Approval"
"Check" + "Vendors"

 

In other words, I need to filter the table by employees and see if each employee has one of four (or all four) prohibited combinations in the field "Permission." 

I was hoping to see something like that or similar in the final report:

 

Prohibited Combinations:  
"Credit Memo" + "Customers"A WolfeEdgar  Manas
"Create Vendor Bills" + "Vendors"A WolfeHasan Yorukoglu
"Make Journal Entry" + "Journal Approval"Ximena CollaEdgar  Manas
"Check" + "Vendors"Hasan Yorukoglu 

 

Could you please give me an advise? (field "Level" is ignored for this task)

 

I would appreciate any help. Thank you.

 

 

0 Replies