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

<tbody>

</tbody>

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

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

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.

Last edited: