Roy_Excel_Island_Apps
Board Regular
- Joined
- Oct 9, 2018
- Messages
- 76
- Office Version
- 365
- Platform
- Windows
Hi, can someone help me to find the formula that I can fill out in column C to count all unique Shop_ID's per Article_ID?
<tbody>
</tbody>
Thanks !
Roy
A | B | C | |
1 | Shop_ID | Article_ID | Count of Unique Shop_ID's for the linked Article_ID |
2 | 205 | 15789 | Result has to be '4' |
3 | 55 | 43187 | |
4 | 206 | 15789 | |
5 | 205 | 15789 | (This is a double one with the first record, so don't count it) |
6 | 55 | 43187 | |
7 | 44 | 43187 | |
8 | 55 | 15789 | |
9 | 44 | 43187 | |
10 | 95 | 15789 |
<tbody>
</tbody>
Thanks !
Roy