Need Formula

[Ron99]

Below is the table

DLM	HISTORY	CATALOGUE
10	12	24
20	56	23
58	30	29

I need the formula to pick the max number and under the result column show the max header.

DLM	HISTORY	CATALOGUE	RESULT
10	12	24	CATALOGUE
20	56	23	HISTORY
58	30	29	DLM

 

[Peter_SSs]

Try below (but have you thought about if it is possible and what should happen if more than one cell in the row contains the max value?)

24 10 09.xlsm
	A	B	C	D
1	DLM	HISTORY	CATALOGUE	RESULT
2	10	12	24	CATALOGUE
3	20	56	23	HISTORY
4	58	30	29	DLM
Header

Cell Formulas
Range	Formula
D2:D4	D2	=INDEX(A$1:C$1,MATCH(MAX(A2:C2),A2:C2,0))

 

[Ron99]

Thank you very much. That helps.

 

[Peter_SSs]

Thank you very much. That helps.

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

What about my question though?

but have you thought about if it is possible and what should happen if more than one cell in the row contains the max value?

For example, is this possible & what results?

24 10 09.xlsm
	A	B	C	D
1	DLM	HISTORY	CATALOGUE	RESULT
2	24	24	24	?
3	23	6	23	?
Header