mardi 9 mars 2021

Count unique values with multiple criteria- Excel

Im using Excel 2016 and I have sheet with 5 columns Risk, Control, Control id, Category, Status. Every risk has more than control, and some of the controls are used for another risk, also some of the controls has the same name but has another id, for that I want to count how many control I have for all risks without counting duplicate id. and also I want to count how many controls that its category is high and status late without counting duplicate. Please I want formula to do that, without using filter.

Data that I have:

      Risk            Control              Control ID            Category         Status
      
      Risk 1         Tech System                1                   High           Late 
                     Construction               2                   Low            Late
      Risk 2         Tech System                1                   High           Late
                     Tech System                3                   Low            Done
      Risk 3             HR                     4                   Low            Done 
                     Construction               2                   Low            Late

Aucun commentaire:

Enregistrer un commentaire