simple MAX + comparison formula

[j0e]

hi

ok here's my question. i have 4 columns (A:D). for each row, i need the 5th cell to say which is the highest. lets say a-d are apples, oranges, bananas, pears. and the spread looked like this:

A O B P
5 7 3 5
1 8 2 4
1 0 6 4
8 2 6 3

i would want to add a 5th column that figures out which of A-D is highest and tells me. so it would look like this:

A O B P Max
5 7 3 5 O
1 8 2 4 O
1 0 6 4 B
8 2 6 3 A

i'm not worried about ties (they will be very rare) so you can have an error or give the wrong answer, whatever.

thanks very much for your help

 

[PA HS Teacher]

Since you're not worried about ties, how about something like this?

Book1
	A	B	C	D	E
1	A	O	B	P	Max
2	5	7	3	5	O
3	1	8	2	4	O
4	1	0	6	4	B
5	8	2	6	3	A
Sheet1

In E2 and pasted down:

=INDEX(A$1:D$1,MATCH(MAX(A2:D2),A2:D2,0))

 

[j0e]

i cou;dnt get index to work but offset with your same formula worked great thank you very much