I have a work/marksheet where column BJ is the possible mark and Column BK is the actual mark. Column BL is the the percentage with column BM has a code for example C1. I have 7 sections in total. I have done the formula to pick out the Maximum and minimum percentage marks. I wan to output the cell next to the percentage maximum and minimum mark. C!
BJ BK BL BM
<tbody>
</tbody>Possible Mark,
BJ BK BL BM
Possible | Actual | % | Code | Possible | Actual | % | Code |
13 | 6 | 46 | C1 | 6 | 4 | 67 | C2 |
<tbody>
</tbody>