Below is an example table.
What I am after is for a excel forumula to count the number of instances that a item is unique in a set of three as below;
Here is the "data/source" table:
And here is how I want the output table to be:
So that for each supplier, the excel forumula calculates how many products are unique.
If a supplier has "£0.00" in the quantity band it would assume they do not supply that product.
Your input would be really appreciated.
What I am after is for a excel forumula to count the number of instances that a item is unique in a set of three as below;
Here is the "data/source" table:
Book3.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | ProductID | SupplierName | Quantity1-10 | PriceRank | ||
2 | 1 | ABC | 0.00 | Low | ||
3 | 1 | DEF | 54.60 | Middle | ||
4 | 1 | GHI | 156.00 | High | ||
5 | 2 | ABC | 0.00 | Low | ||
6 | 2 | DEF | 0.00 | Middle | ||
7 | 2 | GHI | 156.00 | High | ||
8 | 3 | GHI | 0.00 | Low | ||
9 | 3 | ABC | 0.00 | Middle | ||
10 | 3 | DEF | 156.00 | High | ||
11 | 4 | DEF | 0.00 | Low | ||
12 | 4 | ABC | 0.00 | Middle | ||
13 | 4 | GHI | 156.00 | High | ||
Sheet1 |
And here is how I want the output table to be:
Book3.xls | ||||||
---|---|---|---|---|---|---|
D | E | F | G | |||
16 | Supplier | NumberofProductsbeingthesolesupplier | ||||
17 | ABC | 0 | ||||
18 | DEF | 1 | ||||
19 | GHI | 2 | ||||
20 | etc | etc | ||||
Sheet1 |
So that for each supplier, the excel forumula calculates how many products are unique.
If a supplier has "£0.00" in the quantity band it would assume they do not supply that product.
Your input would be really appreciated.