There is a simple way. Firstly, the data table is sorted: the first-level keyword is school, the second-level keyword is math score, and the third-level keyword is sorted in descending order of total score. Then, select the school name through advanced filtering, copy the non-duplicate school name to column A of another table, and use the formula, for example:
Column B: offect (cell a 1 in the data table, match(B2, A:A, 1 in the data table).
Column C: offect (cell a 1 in data table, match(B2, A: A, 0 in data table)+1,1)
Column d: offect (cell a 1 in the data table, match(B2, a: a, 0 in the data table)+2, 1)
Column E: offect (cell a 1 in data table, match(B2, a: a, 0 in data table)+3, 1)
Column f: offect (cell a 1 in the data table, match(B2, a: a, 0 in the data table)+4, 1)
Then copy the formula from column B to column F, which is the name of the top five math scores in each school. The top five math scores of each school use the same formula above after column G, but you need to change this keyword to total score sorting. If you want to get the total score of the top five math scores, you can use the above formula directly without reordering, but to get the relevant parameters, you only need to change 1 in front of the last bracket of the formula to 3.
Please note that cell a 1 in the data table cannot be changed.
I hope I can help, but I don't know what to ask.