Google Sheets: IF permission matches then Compare Two Cells both with delimited values and find differences

jsasiadek35

New Member
Joined
Oct 21, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
ABDF
PermissionAccessPermissionAccess
Can Edit Sku InformationWarehouse UserCan Create Freight MovesLinehaul Control
Can ImportWarehouse User,Power UserCan Edit Facility AddressTSA Group
Can Make Return LabelsPower UserCan Edit Sku InformationWarehouse User
Can Manage Skus FulfillmentDirectCan ImportWarehouse User
Can Adjust Inventory LevelsDirectCan ProcessWarehouse User
Can ProcessWarehouse User,Power UserCan Receive Remote CrossingsLinehaul Control
Can Receive Remote CrossingsLinehaul ControlCan Set Known ShipperTSA Group
Can Set Known ShipperTSA GroupCan UnprocessWarehouse User
Can UnprocessPower User,Warehouse UserCan Use Operations Features (Standard)Warehouse User
Can Use Operations Features (Standard)Power User,Warehouse UserCreate ShipmentsWarehouse User
Create LinehaulPower UserSee All Entity ClientsLinehaul Control
Create ShipmentsWarehouse User,Power UserSee Freight Management SystemLinehaul Control
2See ShipmentsWarehouse User,Linehaul Control
The goal of this is to compared the permissions, if they are a match then check out the Access and see if there is any difference between the matching permission's Accesses.
For example "Can process" would be a match and the difference between the Accesses would be the left user has Power User access that is different from the user on the right.

I am using google sheets which is not too great but for the first part matching the permissions I have:
=IF(COUNTIF($D:$D, $A2)=0, "User 2 does not have permission:", "Both users have permission:")

Having issues first off just comparing the cells with the delimited commas to each other for the difference
Then being able to incorporate it into the first formula so when it does find the match it will then find the difference between the access if any.

Any help would be appreciated as I've been stuck trying different things for numerous hours and can't seem to piece it together
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Forum statistics

Threads
1,215,560
Messages
6,125,523
Members
449,236
Latest member
Afua

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top