Forum Discussion
List top 5 students in a given year and class
Hello,
I'm looking for a more elegant formula solution.
I want to take the top 5 scores from a certain year and class.
I want to list the corresponding names of the students who got those scores.
This is a small scale hypothetical data set.
The real problem contains over 20 fields of criteria, 100's of thousands of rows and to be ranked top 20 instead of top 5 like in the file.
The problem,
There are duplicates of the same top scores.
The solution formula I have come up with is clunky and painstakingly slow to run.
Any Excel experts who can help out, I would much appreciate it.
Pug-Mug1 I see, this indeed does not work well in a pivottable. You could use PowerQuery for that (Data tab, Get & Transform group), see attached. After entering new filter values above te green table, hit the Refresh all button on the data tab.
6 Replies
Pug-Mug1 This is easy (and performs really well!) if you use a pivot table, see attached.
Thanks, I did try to use pivot tables but Sheet 2 I think demonstrates my issue with pivot tables.
For some reason the product code is grouped together. I want to treat International and Domestic suppliers of the same product as different entities.
Another issue is the product code "WIRY" is totally out of order.
I go to "More Sort Options" then select Descending by Discount.
Appreciate any light you can shed on this.
- On which (set of) category do you wish to see the top n discounts precisely?
