Is there a way that we are able to automate the conflict checking:
1. The Conflict matrix is a 2-dimensional array "lookup table" where a given function's row position is the same as its column position (all functions down by same all functions across). The intersection of a function with itself is always ok, and the intersection of a function with another function is subject to the "X" test as we defined as a group.
2. The user access rights report, for each user record is a 1-dimensional array (1x109) where NO is always ok and each "YES" needs to be evaluated by taking the first "YES" occurrence and comparing it to all the other "YESs" for that user record considering the criteria from the Conflict Matrix
So I think we are talking DO...UNTIL loops, dimensional lookups, and IF...THENs, etc. etc. -- e.g. programming.
Is there anyway programmatically or within excel to accomplish this?