Top 10 from a list

[jbanks]

Hi

In the attached I have hundreds of students (anonymised), they are all in different year groups. To the right I want to be able to pull the top 10 students from each of the year groups based on the Rewards total.

I know I can use filters but I want to use formulas which will update the lists when the points values change in the future.

Please help!

Thanks

Jeff

[José Augusto]

Hi

Try this formula in G3 and drag down and forward

Please Login or Register  to view this content.

[kvsrinivasamurthy]

Pl see the file.Note the changes in both the tables.
ARRAY formula in G3 then copied across.

=IFERROR(LARGE(IF($B$2:$B$294=G$2,$D$2:$D$294,""),$F3),"")

ARRAY formula is used

To enter ARRAY formula
Paste the formula
Press F2
Press Ctrl+Shift+Enter keys together.
formula will be covered with{} brackets by excel.

[jbanks]

Hi

thanks for replying but i would like to pull the students names instead if possible.

Any ideas?

Thanks again

Jeff

[José Augusto]

Hi
Have you seen the post #2?
See the file

[6StringJazzer]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)