Dharris144
Board Regular
- Joined
- Jul 22, 2009
- Messages
- 97
Hello everyone,
I have a spreadsheet "roles" Column A has user name Columns B:Z have their roles
Example
John Doe Display Edit Modify
I export another spreadsheet from our ERP a list of user and roles but it is only two columns so
John Doe Display
John Doe Edit
John Doe Delete
So how do I know if John Doe has a role that is not in the spreadsheet?
Example John Doe Delete is not in the "roles" spreadsheet.
maybe index match?
I have a spreadsheet "roles" Column A has user name Columns B:Z have their roles
Example
John Doe Display Edit Modify
I export another spreadsheet from our ERP a list of user and roles but it is only two columns so
John Doe Display
John Doe Edit
John Doe Delete
So how do I know if John Doe has a role that is not in the spreadsheet?
Example John Doe Delete is not in the "roles" spreadsheet.
maybe index match?