Formula help

Highlighted
Deleted
Not applicable

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

1 Reply

Hi,

 

As variant, you may add helper column like here

image.png

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.