Creating a list by referencing a seperate table

[Cennyan]

I'm trying to create a list referencing a table such as below:

Name	Grade
Albert	A
Brian	B
Chris	C
Dave	D
Ethel	A
Frank	B
Gary	A
Henry	F

<tbody>
</tbody>

which will then list all students that have a particular grade. So referencing the above, the final result would look like:

Students with A's

Albert

Ethel

Gary

<tbody>
</tbody>

Using

=INDEX(A:A,MATCH("A",B:B,0))

I can get the first value of A to populate, the additional cells return the same value (IE, they all return Albert). I had thought to use COUNTIF

=INDEX(A:A,MATCH("A",COUNTIF($C$2:C2,B:B),0))

where $C$2:C2 Is the actual column which contains the formula. 2nd cell would be $C$2:C3 and so on. Using this formula it simply returns a 0.

 

[Aladin Akyurek]

Try to post a small sample along with the desired results.

 

[Cennyan]

It was easier to upload to google docs. https://drive.google.com/open?id=0B3RWXzuH0ysvUjBsTjFkRDhJSk0

I'm trying to create a dynamic work schedule that references the Master Names tab to auto-populate the current day tab. In this case, only Sunday shows up and only one of the 15 job codes are being used for simplicity.

On the Master Names tab there are five sections which could prevent a persons name from showing up in the auto-populated list for Sunday: Unexcused Absence, Excused Absence, Light Duty, New Hire Training and Vacation. Each section is broken down in to Six days of the week Sun - Fri. If someone is out for one of those given days we'll put an X in that cell. On the Sunday tab, if there is an X present in the Sunday Column of one or more of the 5 sections on the Master Names sheet, then they will not populate as part of Sunday's Schedule.

I was able to reference all the Sunday Sections on the COUNTIFS using:

=COUNTIFS('Master Names'!$C:$C,Sunday!$G18,'Master Names'!$D:$D,"<>X",'Master Names'!$J:$J,"<>X",'Master Names'!$P:$P,"<>X",'Master Names'!$V:$V,"<>X",'Master Names'!$AB:$AB,"<>X")

It didn't seem to work on the index which references the name:

=IFERROR(INDEX('Master Names'!$B:$B,SMALL(IF('Master Names'!$C:$C=$G$18,IF(1-('Master Names'!$D:$D="X"),ROW('Master Names'!$B:$B)-MIN(ROW('Master Names'!$B:$B))+1)),ROWS(C$3:C3))),"")

 

[Cennyan]

Is this something that can't be done?

 

[Cennyan]

This is the formula I finally came up with

=IFERROR(INDEX('Master Names'!$F:$F,SMALL(IF('Master Names'!$G:$G=$Q$16,IF(1-(('Master Names'!$J:$J="X")+('Master Names'!P:P="X")+('Master Names'!V:V="X")+('Master Names'!AB:AB="X")+('Master Names'!AH:AH="X")),ROW('Master Names'!$F:$F)-MIN(ROW('Master Names'!$F:$F))+1)),ROWS(K$13:K42))),"")