Excel- Identify column headers if duplicate max values in a row

[lixx]

Im trying to find a way to identify the column header of the maximum value on a row. In my case the column headers are values such as 1 , 2, 3, 4 and 5 which i would be using in another statistic. I actually want to get the column header value which has the max value in a row. Im working INDEX ,MATCH, MAX to identify the column header but since there is duplicate max value its returning to the first instance (column header 1). however i want to get both column headers which has the max value.
for example

5	4	3	2	1	6
40.0%	10.0%	40.0%	0.0%	10.0%	0.0%

here i want to get the header value for the max % . in this case 40% is duplicated and which i apply INDEX ,MATCH, MAX it is giving me 5 which is not what i want... so how can i get the average of the two column header values which has 40.0%.
Please help me.. is there any solution for it

 

[Peter_SSs]

Welcome to the MrExcel board!

how can i get the average of the two column header values which has 40.0%.

Like this?

22 02 28.xlsm
	A	B	C	D	E	F
1	5	4	3	2	1	6
2	40.00%	10.00%	40.00%	0.00%	10.00%	0.00%
3
4	Average	4
Averageifs

Cell Formulas
Range	Formula
B4	B4	=AVERAGEIFS(A1:F1,A2:F2,MAX(A2:F2))

 

[lixx]

Welcome to the MrExcel board!


Like this?

22 02 28.xlsm
	A	B	C	D	E	F
1	5	4	3	2	1	6
2	40.00%	10.00%	40.00%	0.00%	10.00%	0.00%
3
4	Average	4
Averageifs

Cell Formulas
Range	Formula
B4	B4	=AVERAGEIFS(A1:F1,A2:F2,MAX(A2:F2))

Thank you so much.. it works and that is exactly what i want. you have saved my day

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.

 

[liyifeng]

You're welcome. Thanks for the follow-up.

Hi do you know how could I get 5 and 3 instead of their average value?

 

[Peter_SSs]

22 09 12.xlsm
	A	B	C	D	E	F
1	5	4	3	2	1	6
2	40%	10%	40%	0%	10%	0%
3
4	Result	5,3
Equal max

Cell Formulas
Range	Formula
B4	B4	=TEXTJOIN(",",,FILTER(A1:F1,A2:F2=MAX(A2:F2)))

 

[liyifeng]

22 09 12.xlsm
	A	B	C	D	E	F
1	5	4	3	2	1	6
2	40%	10%	40%	0%	10%	0%
3
4	Result	5,3
Equal max

Cell Formulas
Range	Formula
B4	B4	=TEXTJOIN(",",,FILTER(A1:F1,A2:F2=MAX(A2:F2)))

Thank you so much that's magical

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.