# Rank based on sum in a long list!

#### Nightjester

##### New Member
Hi, I have a long list of University courses by course year, each year has a number of modules with a value, this value can be 2, 1 or .5. Students study modules that have a total value of 6. What I am trying to do is identify the most popular modules in each program year. So I have ordered the list by the modules with the most students on, I then need to highlight the top modules when the value totals 6 (this could be top 6 modules with a value of one, or top 3 with a value of 2 etc.)

Course, Year, Module, Count, Value
Physics, 1, Water ,8, 2
Physics, 1, Earth, 8, 1
Physics, 1, Air, 7, 2
Physics, 1, Fire, 7, 1
Physics, 1, Metals, 3, 1
Physics, 2, Water, 7, 2 etc.........

So in this example the top 4 rows would be the ones I needed, the list would then continue with year 2 modules & I need to start the process again.

In Summary - once the sum of the value column hits 6, somehow highlight those rows or cells, then skip to the next year for that course & repeat

### Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Maybe try:

=SUMPRODUCT(--(A\$2:A2=A2),--(B\$2:B2=B2),E\$2:E2)<=6

Brilliant, Many Thanks

Replies
1
Views
64
Replies
2
Views
173
Replies
1
Views
176
Replies
5
Views
215
Replies
4
Views
204

1,207,280
Messages
6,077,506
Members
446,287
Latest member
tjverdugo85

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back