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....