[xpost][/xpost]
Hi
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.
Please help!
Thanks
Jeff