mikewongbiz
New Member
- Joined
- Jan 25, 2015
- Messages
- 19
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
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