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
[TABLE="width: 500"]
<tbody>[TR]
[TD]Possible[/TD]
[TD]Actual[/TD]
[TD]%[/TD]
[TD]Code[/TD]
[TD]Possible[/TD]
[TD]Actual[/TD]
[TD]%[/TD]
[TD]Code[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]6[/TD]
[TD]46[/TD]
[TD]C1[/TD]
[TD]6[/TD]
[TD]4[/TD]
[TD]67[/TD]
[TD]C2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Possible Mark,
BJ BK BL BM
[TABLE="width: 500"]
<tbody>[TR]
[TD]Possible[/TD]
[TD]Actual[/TD]
[TD]%[/TD]
[TD]Code[/TD]
[TD]Possible[/TD]
[TD]Actual[/TD]
[TD]%[/TD]
[TD]Code[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]6[/TD]
[TD]46[/TD]
[TD]C1[/TD]
[TD]6[/TD]
[TD]4[/TD]
[TD]67[/TD]
[TD]C2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Possible Mark,