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.
