peterhinton
Active Member
- Joined
- Mar 8, 2016
- Messages
- 336
how would I count the number of unique branch numbers in the below table, that have the partner TRU, and Country SWITZERLAND ?
The desired answer would be 4
or TRU and FRANCE would return 2
Data Starts in A1
<tbody>
</tbody><colgroup><col span="2"><col></colgroup>
The desired answer would be 4
or TRU and FRANCE would return 2
Data Starts in A1
BRANCH | PARTNER | SWITZERLAND |
1200 | TRU | SWITZERLAND |
1200 | TRU | SWITZERLAND |
1201 | TRU | SWITZERLAND |
1201 | TRU | SWITZERLAND |
1202 | TRU | SWITZERLAND |
1451 | TRU | FRANCE |
1451 | TRU | FRANCE |
1451 | TRU | FRANCE |
1451 | TRU | FRANCE |
1451 | TRU | FRANCE |
1452 | TRU | FRANCE |
1452 | TRU | FRANCE |
1706 | TOY | SPAIN |
1706 | TRU | SWITZERLAND |
1706 | TRU | SWITZERLAND |
<tbody>
</tbody><colgroup><col span="2"><col></colgroup>