Forum Discussion

Pug-Mug1's avatar
Pug-Mug1
Copper Contributor
Apr 14, 2019
Solved

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...
excel
Formulas and Functions
  • JKPieterse's avatar
    JKPieterse
    Apr 18, 2019

    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.

JKPieterse's avatar
JKPieterse
Silver Contributor
Apr 15, 2019

Pug-Mug1 This is easy (and performs really well!) if you use a pivot table, see attached.

Pug-Mug1's avatar
Pug-Mug1
Copper Contributor
Apr 15, 2019

JKPieterse 

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.