Please see the attached, ultimately need help with is writing a formula or code that will be able to differentiate profile groups on sheet 1 and return any instances where the matrix (on sheet 2) may indicate an issue exists within a profile. Issues are identified with an 'x' in the matrix. The formula would be entered in column E of sheet 1 and run all the way down the data set.
A brief example would be:
Let's say a profile could not have both "Account Inquiry" and "All Miscellaneous Entries". The matrix would show an 'x' in the cells where Account Inquiry and All Miscellaneous Entries cross (if you look at the attachment you will see on sheet 2 an 'x' in cells E21 and W3) which identifies this as a conflict. With that said, if a profile on sheet 1 (Column B) has both Account Inquiry and All Miscellaneous entries listed in Column C, Cell E on Sheet 1 should indicate the issue in some fashion.
Can anyone help me out???C3 SOD Mapping.xlsx
Password for the file is just the number 1
Bookmarks