hi all,
i have to display the highest 3 ranks and corresponding name of the first three rank students (note: if two students got first rank means, i have to display the two students name).

my formula i have tried is: =ArrayFormula((INDEX($B$5:$B$9,SMALL(IF($C$5:$C$9=MAX($C$5:$C$9),ROW($C$5:$C$9)-1),ROW(C5)-1))))
iam getting the error :#NUM! -> 'Function SMALL parameter 2 value 4 is out of range'. in google sheet