Hi
I'm dealing with a spreadsheet of user information regarding access changes and I need help producing a template or efficient method of verifying details. To make it easy, I'll explain what I need:
I have data organized by columns including a NETWORK USER ID, USER NAME, ROLES ASSIGN, & STATUS ACTION field values. What I basically need to do is check each NETWORK USER ID and filter the data to see how many USER NAMEs were assigned to them to them to verify access and what the STATUS ACTION is. STATUS ACTION can be either (APPROVED) or (REJECTED) and I want to see how many are rejected in addition. I have been able to pull the information for the majority of the NETWORK USER IDS but the problem is that some of the NETWORK USERs never responded to the request so therefore the value in their STATUS ACTION cells is blank.
For the purpose of my work, I need to check if the same combination of USER NAME - ROLES ASSIGN was approved by another NETWORK USER ID because when a NETWORK USER ID is assigned USER IDS to approve/reject, multiple NETWORK USER IDS are often assigned the same USER NAMEs and all we are concerned with is that atleast one of the NETWORK USER IDS approved/rejected the change so that each USER NAME -ROLES ASSIGN combo is accounted for.

Now I can do this cross-lookup easily for some of the NETWORK USER IDs that have 4-5 USER NAMES assigned to them but it is time consuming and inefficient for a NETWORK USER ID that has 50+ USER NAME - ROLES ASSIGNED combinations that they had to review.

So what I need help with is creating a template based on excel logic, etc. that allows me to filter the NETWORK USER IDS and have constraints on the other fields in order to display the list of USER NAME- ROLES ASSIGNED that weren't APPROVED or REJECTED by the NETWORK USER ID to see if another NETWORK USER ID that was assigned the same USER-NAME ROLES ASSIGNED has a value for the STATUS ACTION field.

I'm not sure if this is something I would be able to do or if I'm better just printing out a master list of the data and using it to cross-reference the data rather than switching back and forth between filters on excel to check each NETWORK USER ID.

If anyone can provide some suggestions or help I appreciate it