Hello,
I have a table which tells me which class a student is in
<colgroup><col><col span="4"></colgroup><tbody>
</tbody>
I would like to change this into a list of students in each class
<colgroup><col width="64" style="width:48pt" span="8"> </colgroup><tbody>
</tbody>
Below each number I would like a list of the students in that class
So below class 1 it would say StudentA and then the row below would say StudentD
I can create the lists using COUNTIF but I end up with blank rows (which I don't want)
Is there a formula, that can make this from the table above?
<colgroup><col width="64" style="width:48pt" span="8"> </colgroup><tbody>
</tbody>
Thank you
I have a table which tells me which class a student is in
Student | Group1 | Group2 | Group3 | Group4 |
StudentA | 2 | 3 | 4 | 6 |
StudentB | 3 | 4 | 1 | 7 |
StudentC | 6 | 5 | 4 | 2 |
StudentD | 2 | 3 | 7 | 1 |
<colgroup><col><col span="4"></colgroup><tbody>
</tbody>
I would like to change this into a list of students in each class
Class | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
Student |
<colgroup><col width="64" style="width:48pt" span="8"> </colgroup><tbody>
</tbody>
Below each number I would like a list of the students in that class
So below class 1 it would say StudentA and then the row below would say StudentD
I can create the lists using COUNTIF but I end up with blank rows (which I don't want)
Is there a formula, that can make this from the table above?
Class | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
Student | StudentB | StudentA | StudentA | StudentA | StudentC | StudentA | StudentD |
StudentD | StudentC | StudentB | StudentB | StudentC | |||
StudentD | StudentD | StudentC |
<colgroup><col width="64" style="width:48pt" span="8"> </colgroup><tbody>
</tbody>
Thank you