Change the Ranges 'Student Data'!$C$7:$C$41 & 'Student Data'!$G$7:$G$41 according to your needs like
if your data has 200 Rows then change the formula like
=IF(ISERROR(INDEX('Student Data'!$C$7:$C$2000,LARGE(INDEX(('Student Data'!$G$7:$G$2000="M")*ROW(INDIRECT("1:"&ROWS('Student Data'!$G$7:$G$2000))),0),COUNTIF('Student Data'!$G$7:$G$2000,"M")-ROWS(B$12:B12)+1))),"",INDEX('Student Data'!$C$7:$C$2000,LARGE(INDEX(('Student Data'!$G$7:$G$2000="M")*ROW(INDIRECT("1:"&ROWS('Student Data'!$G$7:$G$2000))),0),COUNTIF('Student Data'!$G$7:$G$2000,"M")-ROWS(B$12:B12)+1)))
for Boys and
=IF(ISERROR(INDEX('Student Data'!$C$7:$C$2000,LARGE(INDEX(('Student Data'!$G$7:$G$2000="F")*ROW(INDIRECT("1:"&ROWS('Student Data'!$G$7:$G$2000))),0),COUNTIF('Student Data'!$G$7:$G$2000,"F")-ROWS(B$43:B43)+1))),"",INDEX('Student Data'!$C$7:$C$2000,LARGE(INDEX(('Student Data'!$G$7:$G$2000="F")*ROW(INDIRECT("1:"&ROWS('Student Data'!$G$7:$G$2000))),0),COUNTIF('Student Data'!$G$7:$G$2000,"F")-ROWS(B$43:B43)+1))) for girls