Hi there,
I have a document where students scores are inputted in column N:AJ with the column headers as the categories.
I am wanting in columns C:E to pick out the 3 lowest scores and their corresponding categories.
I have used the following formula: =(INDEX($N$1:$AJ$1,MATCH(SMALL(N3:AJ3,1),N3:AJ3,0))) which works for 1 value, but there are multiple values the same. I would like the formula to pick the bottom 3 categories, even when they all score the same.
I've tried to put an example below;
<tbody>
</tbody>
Hope you can help!
I have a document where students scores are inputted in column N:AJ with the column headers as the categories.
I am wanting in columns C:E to pick out the 3 lowest scores and their corresponding categories.
I have used the following formula: =(INDEX($N$1:$AJ$1,MATCH(SMALL(N3:AJ3,1),N3:AJ3,0))) which works for 1 value, but there are multiple values the same. I would like the formula to pick the bottom 3 categories, even when they all score the same.
I've tried to put an example below;
Name | 1st | 2nd | Graph | Number | Algebra | Multiplication |
Tony | ? | ? | 5 | 3 | 2 | 2 |
Jack | ? | ? | 0 | 0 | 0 | 2 |
<tbody>
</tbody>
Hope you can help!