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%3CLINGO-SUB%20id%3D%22lingo-sub-2356877%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Advice%20-%20Finding%20prohibited%20combinations%20of%20permissions%20among%20employees%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2356877%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F756612%22%20target%3D%22_blank%22%3E%40AnnaVWilliamson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20modified%20your%20workbook%20to%20have%20a%20Combo%20Task%20Selector%20drop%20down%20list%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yea_So_0-1621070421769.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F280838iDAE2471E20182A7C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yea_So_0-1621070421769.png%22%20alt%3D%22Yea_So_0-1621070421769.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CTABLE%20width%3D%22402px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2279px%22%3E%3CPRE%3ECombo%23%3C%2FPRE%3E%3C%2FTD%3E%3CTD%20width%3D%22172px%22%3E%3CPRE%3ETask1%3C%2FPRE%3E%3C%2FTD%3E%3CTD%20width%3D%22150.667px%22%3E%3CPRE%3ETask2%3C%2FPRE%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2279px%22%3E%3CPRE%3E0%3C%2FPRE%3E%3C%2FTD%3E%3CTD%20width%3D%22172px%22%3E%3CPRE%3EALL%3C%2FPRE%3E%3C%2FTD%3E%3CTD%20width%3D%22150.667px%22%3E%3CPRE%3EALL%3C%2FPRE%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2279px%22%3E%3CPRE%3E1%3C%2FPRE%3E%3C%2FTD%3E%3CTD%20width%3D%22172px%22%3E%3CPRE%3ECredit%20Memo%3C%2FPRE%3E%3C%2FTD%3E%3CTD%20width%3D%22150.667px%22%3E%3CPRE%3ECustomers%3C%2FPRE%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2279px%22%3E%3CPRE%3E2%3C%2FPRE%3E%3C%2FTD%3E%3CTD%20width%3D%22172px%22%3E%3CPRE%3ECreate%20Vendor%20Bills%3C%2FPRE%3E%3C%2FTD%3E%3CTD%20width%3D%22150.667px%22%3E%3CPRE%3EVendors%3C%2FPRE%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2279px%22%3E%3CPRE%3E3%3C%2FPRE%3E%3C%2FTD%3E%3CTD%20width%3D%22172px%22%3E%3CPRE%3EMake%20Journal%20Entry%3C%2FPRE%3E%3C%2FTD%3E%3CTD%20width%3D%22150.667px%22%3E%3CPRE%3EJournal%20Approval%3C%2FPRE%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2279px%22%3E%3CPRE%3E4%3C%2FPRE%3E%3C%2FTD%3E%3CTD%20width%3D%22172px%22%3E%3CPRE%3ECheck%3C%2FPRE%3E%3C%2FTD%3E%3CTD%20width%3D%22150.667px%22%3E%3CPRE%3EVendors%3C%2FPRE%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20replace%20the%20report%2C%20paste%20the%20new%20or%20updated%20report%20in%20the%20FilterList%20Tab%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yea_So_2-1621070785479.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F280841iE71CF05FC12BD25A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yea_So_2-1621070785479.png%22%20alt%3D%22Yea_So_2-1621070785479.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EYou%20can%20also%20update%20the%20drop%20down%20list%20in%20the%20ComboTaskSelectList%20Tab.%3C%2FP%3E%3CP%3ELet%20me%20know%20if%20you%20have%20any%20questions.%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%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.

 

 

1 Reply

Hi @AnnaVWilliamson 

 

I modified your workbook to have a Combo Task Selector drop down list:

Yea_So_0-1621070421769.png

Combo#
Task1
Task2
0
ALL
ALL
1
Credit Memo
Customers
2
Create Vendor Bills
Vendors
3
Make Journal Entry
Journal Approval
4
Check
Vendors

 

To replace the report, paste the new or updated report in the FilterList Tab:

Yea_So_2-1621070785479.png

You can also update the drop down list in the ComboTaskSelectList Tab.

Let me know if you have any questions.

Cheers