Return Max on Multiple Columns

[mikewongbiz]

Hi all, I am a newbie to Excel and haven't been able to work this out:

Name Results1 Results2 Results3 Results4
Tom 55 80 45 60
Ken 70 67 48 90
Craig 40 95 47 75

Q1: Any ideas of a formula to search for the MAX in the range B2:E4 and Return the name from A Column.

Eg. the MAX in the numbers above is 95 which is found in C4 and will return Craig.

I can achieve only with one column using Index and Match, but, not with multiple columns. Any suggestions/help much appreciated !

Thanks,
Mike

 

[Marcelo Branco]

Hi Mike

Welcome to Mr Excel

Maybe something like this

	A​	B​	C​	D​	E​	F​	G​
1​	Name​	Results1​	Results2​	Results3​	Results4​		Formula​
2​	Tom​	55​	80​	45​	60​		Craig​
3​	Ken​	70​	67​	48​	90​
4​	Craig​	40​	95​	47​	75​
5​

Formula in G2
=INDEX($A$2:$A$4,MAX(INDEX((B2:E4=MAX(B2:E4))*(ROW(B2:E4)-ROW(B2)+1),)))

Hope this helps

M.

 

[mikewongbiz]

Hi Marcelo Branco,

You are great! It works like a charm...

Mike

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.