G Guest Feb 19, 2006 #1 if i use max to find the bowlers high score, how can i find the bowlers name who bowled the high score??
if i use max to find the bowlers high score, how can i find the bowlers name who bowled the high score??
P Peo Sjoblom Feb 19, 2006 #2 What do you want to do with ties? =INDEX(A2:A50,MATCH(MAX(B2:B50),B2:B50,0)) will match the first occurrence of a max value on B and return name from A -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com Portland, Oregon
What do you want to do with ties? =INDEX(A2:A50,MATCH(MAX(B2:B50),B2:B50,0)) will match the first occurrence of a max value on B and return name from A -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com Portland, Oregon
B Biff Feb 19, 2006 #3 Hi! Try this: =INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0)) What happens if more than 1 person rolls the high score? Biff
Hi! Try this: =INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0)) What happens if more than 1 person rolls the high score? Biff
