Top 10 from list

jbanks · Sep 21st 2020

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

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

Fluff13 · Sep 22nd 2020

If you have the dynamic array functions in G3 copied right

=INDEX(SORT(FILTER($A$2:$D$294,$B$2:$B$294=G2),4,-1),SEQUENCE(10))

jbanks · Sep 22nd 2020

thank you but sadly I dont have dynamic array functions

Fluff13 · Sep 22nd 2020

Ok, but as you have already got a working formula on ExcelForum, I'll step out.

You might also want to have a look at the rules, both here & on EF regarding cross posting.

jbanks · Sep 27th 2020

Admin Please delete this thread/whole thing please

**royUK** · Sep 28th 2020

jbanks

We don't delete threads like that! Read and follow the Rules

Top 10 from list

Share

Similar Threads

Create filter for Listbox populated data from combobox

Vlookup to pull a data from adjacent column