Formula help

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



As variant, you may add helper column like here


with formula


and pivot you range with filter on that column to show only names with unmatched status.