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