nikhil0311
Board Regular
- Joined
- May 3, 2013
- Messages
- 197
- Office Version
- 2013
- Platform
- Windows
Hello Friends,
Need your help to count the IDs based on multiple criteria. If you guys can help me to create a formula to update output section (H4 to K5)
Thank you as always
Need your help to count the IDs based on multiple criteria. If you guys can help me to create a formula to update output section (H4 to K5)
Thank you as always
Book1 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | ID | Product | LOB | Status | Count unique IDs based on multiple criterias | ||||||||
2 | 66545523 | card | CCBSI | Active | Card | Receivables | |||||||
3 | 66545523 | card | CCBSI | Active | Output ---> | Active | Inactive | Active | Inactive | ||||
4 | 11223344 | receivables | CRE | Active | CCBSI | 1 | 1 | 1 | 0 | ||||
5 | 33445566 | card | CRE | Active | CRE | 2 | 0 | 1 | 1 | ||||
6 | 11223344 | card | CRE | Active | |||||||||
7 | 11223344 | receivables | CRE | Inactive | |||||||||
8 | 66545523 | card | CCBSI | Inactive | |||||||||
9 | 11223344 | receivables | CCBSI | Active | |||||||||
10 | 33445566 | receivables | CRE | Active | |||||||||
11 | 66545523 | receivables | CRE | Inactive | |||||||||
Sheet1 |