what is the formula for ranking the top 5 supplier spend in each sales category? with the remainder rolled up and totalled, aslo showing the number of "other" suppliers. my data set is a list of purchase orders from all suppliers categorised into commodity groups.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
top 5 suppliers per category with rest in tail
- Thread starter ajm
- Start date
hagia_sofia
Active Member
- Joined
- May 10, 2024
- Messages
- 461
- Office Version
- 365
- Platform
- Windows
You are probably looking for some combination of e.g. FILTER and LARGE. Could you please post a sample of your data so that the answer could be more specific?
Upvote
0
