Forum Discussion

Deleted's avatar
Deleted
Feb 07, 2019

Formula help

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

BI & Data Analysis
excel
Formulas and Functions

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Feb 07, 2019

    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.