How to select top 3 based on school and put show the rest data below the top three

[shelbymarsa]

I've been working on how to sort and prioritize a table. I have a table contains 3 columns: school,student name and exam mark. I want to select top 3 name with higher exam mark for each school and then sort it higher mark to the lowest, and the rest data would be stored below the top 3. What VBA code for this? Help me please.

here's my file
data dummy.xlsm

[alansidman]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

[vlady]

Dupl.

You can continue with the other one. Thanks.

Thread Closed .