create rank top 10 and lowest 10 of students score ( no duplicate rank ) include 0 value,category

agusgustoPlease see if the formula in the attached workbook work for you.

Top scores by location:

=SORTBY(FILTER(data!C5:C11,data!B5:B11=$C$5,"-"),FILTER(data!AI5:AI11,data!B5:B11=$C$5,"-"),-1)

Bottom scores by location

=SORTBY(FILTER(data!C5:C11,data!B5:B11=$C$5,"-"),FILTER(data!AI5:AI11,data!B5:B11=$C$5,"-"),1)

Rank per class:

=SORTBY(FILTER(data!C5:C11,data!A5:A11=$C$5,"-"),FILTER(data!AI5:AI11,data!A5:A11=$C$5,"-"),-1)

I would recommend that, in your real schedules, you use structured tables and/or dynamic named ranges. This will avoid you from having to update the cell references every time the data ranges change. 

Furthermore, consider getting rid of merged cells. You seem to use them for cosmetic reasons only.  And make sure that the location names and class codes are spelled exactly the same in both the data and the ranking tables. I found both locations "sumatra" and "sumatra " (i.e. with a space at the end). Similarly for classes, I found "C" and "C ".