Formula Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In the chart below, John, Joe, and Bob have golf scores listed for the first
2 holes. Column E is the Min Value which is a formula that pulls the low
value/score for each hole. In column E, I would to insert a formula to pull
the golfer's name (John, Joe, Bob) depending on who has the low score/min
value. Any ideas? Thank you!

Hole# John Joe Bob MIN VALUE GOLFER w/ low Score
#1 5 4 5 4 ?
#2 3 2 5 2 ?
 
Try:

=INDEX($B$1:$D$1,MATCH(MIN(B2:D2),B2:D2))

--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
 
and if two or more golfers have the same score?...?

Good thinking, I never thought of that!

--
Regards

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
 
Sandy - Thanks that worked....however, as was brought up-- what happens if on
Hole #1, all scores were 5 and I wanted to show a blank cell ("") if there is
no clear cut low score. I only want to show a golfer's name if he won the
hole. Any ideas how to build that into your suggested formula below?
 
HTC,

I was rather hoping that Gary's Student was going to jump in with a solution
:-)

Try:

=IF(COUNT(B2:D2)<>3,"",IF(COUNTIF(B2:D2,MIN(B2:D2))>1,"Tied Hole
("&COUNTIF(B2:D2,MIN(B2:D2))&")",INDEX($B$1:$D$1,MATCH(MIN(B2:D2),B2:D2))))

This shows a blank until data is entered, (change the range and <>3 to the
number of players),
"Tied Hole" with the number of player tying in brackets.
or the name of the winner as before.

Note: there is a space between "Tied Hole and ("&

--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
 
Back
Top