Hello Community
I am facing some middle-week crises 🙂
Looks like a simple task, yet not able to crack it.
I have data from A:C columns and need a result in E:G.
Need a COUNT(DISTINCT SKU) according to the Supplier lowest Rating.
| Supplier | Rating | COUNT(DISTINCT SKU) |
| A | 1 | 20 |
| A | 2 | 11 |
| A | 3 | 12 |
| A | 4 | 13 |
| B | 3 | 14 |
| B | 4 | 15 |
| C | 2 | 16 |
| C | 3 | 17 |
| C | 5 | 18 |
Thank you guys!
1 Solution
Accepted Solutions
