Home

Formula help

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies