Feb 07 2019 12:42 PM
Feb 07 2019 12:42 PM
My company had a system outage where everyone lost access to different roles and then gained them back. I need to make sure everyone had all the appropriate roles restored, no more or less.
In the A column are everyone's usernames. In the B column are the actions per user, either "Profile deleted" or "Profile added". I need to make sure for each user, they have the same amount of line items that are "Profile deleted" as "Profile added".
For example, if the user "John Doe" has 4 line items of "profile deleted", I need to make sure he also has 4 line items of "Profile added"
Any help? Thanks
Feb 07 2019 02:04 PM
Hi,
As variant, you may add helper column like here
with formula
=COUNTIFS($A$2:$A$10,A2,$B$2:$B$10,"pa")=COUNTIFS($A$2:$A$10,A2,$B$2:$B$10,"pd")
and pivot you range with filter on that column to show only names with unmatched status.