Minimum and Maximum formula

[d488z]

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

Possible	Actual	%	Code	Possible	Actual	%	Code
13	6	46	C1	6	4	67	C2

<tbody>
</tbody>

Possible Mark,

 

[AlanY]

try this

Book1
	A	B	C	D	E	F	G	H
1	Possible	Actual	%	Code	Possible	Actual	%	Code
2	13	6	46	C1	6	4	67	C2
3
4	max	C2
5	min	C1
Sheet1

Cell Formulas
Range	Formula
B4	=INDEX(A2:H2,MATCH(MAXIFS(A2:H2,A1:H1,"%"),A2:H2,0)+1)
B5	=INDEX(A2:H2,MATCH(MINIFS(A2:H2,A1:H1,"%"),A2:H2,0)+1)

 

[d488z]

Hi Thanks for your reply. I tried pasting the table in a new worksheet and pasting the formula and I have the #N/A......

 

[AlanY]

it should work, have a look of this

https://drive.google.com/file/d/1F8Ty41WFrTou7Sdi2AXfXTi1lTs3PccB/view?usp=sharing