MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
In the attached I have hundreds of students (anonymised), they are all in different years groups. To the right I want to be able to pull the top 10 students from each of the year groups based on the points 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.