DaRTH KiRo
New Member
- Joined
- Jan 24, 2018
- Messages
- 39
- Office Version
- 2016
- Platform
- Windows
I have three columns in my worksheet, column A contains a list of hubs, column B contains a list of suppliers, and column C contains a sum of their business. The hub in the cell of column A repeats for every supplier they have before moving onto a new hub. Below is an example of what the data looks like; however, there are thousands of rows. Is there there a way to identify the top 10 suppliers using columns B & C for each hub (column A)? In case it is relevant, multiple hubs may have the same supplier but the sum of business would be different because it is just based on that hub and supplier.
Hub 1 | Supplier Name 1 | 561651 |
Hub 1 | Supplier Name 2 | 32165 |
Hub 1 | Supplier Name 3 | 1596 |
Hub 1 | Supplier Name 4 | 15984 |
Hub 1 | Supplier Name 5 | 1651 |
Hub 2 | Supplier Name 4 | 68573 |
Hub 2 | Supplier Name 5 | 654981 |
Hub 2 | Supplier Name 6 | 16864 |
Hub 2 | Supplier Name 7 | 654 |
Hub 2 | Supplier Name 8 | 156654 |
Hub 3 | Supplier Name 10 | 651 |
Hub 3 | Supplier Name 11 | 984 |
Hub 3 | Supplier Name 12 | 1891 |
Hub 3 | Supplier Name 13 | 15687 |
Hub 3 | Supplier Name 14 | 35489 |
Hub 3 | Supplier Name 15 | 1568 |
Hub 3 | Supplier Name 16 | 68465 |