Re: Return a list of names based on multiple criteria
Assuming same workbook.. add another column to return the Test scores in descending order.
So now, for Quiz 1 you will have 3 columns.. Name, Progress, Test Score.
These formulas are to get Male Only.
In C2:
[COLOR="#0000FF"]=IF(D2="","",INDEX(Sheet1!$A$2:$A$19,SMALL(IF(Sheet1!$C$2:$C$19=$B$1,IF(Sheet1!$B$2:$B$19="M",IF(Sheet1!$D$2:$D$19=D2,IF(Sheet1!$E$2:$E$19=E2,ROW(Sheet1!$D$2:$D$19)-ROW(Sheet1!$D$2)+1)))),COUNTIFS(D$2:D2,D2,E$2:E2,E2))))[/COLOR]
CSE Confirmed and copied down.
In D2:
[COLOR="#0000FF"]=IFERROR(LARGE(IF(Sheet1!$C$2:$C$19=$B$1,IF(Sheet1!$B$2:$B$19="M",Sheet1!$D$2:$D$19)),ROWS(C$2:C2)),"")[/COLOR]
confirmed with CTRL+SHIFT+ENTER and copied down
in E2:
[COLOR="#0000FF"]=IFERROR(LARGE(IF(Sheet1!$C$2:$C$19=$B$1,IF(Sheet1!$B$2:$B$19="M",IF(Sheet1!$D$2:$D$19=D2,Sheet1!$E$2:$E$19))),COUNTIF(D$2:D2,D2)),"")[/COLOR]
CSE Confirmed and copied down.
I will leave the rest to you....