Formula Question

[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 ?

 

[Guest]

and if two or more golfers have the same score?...?

 

[Sandy Mann]

Try:

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

--
HTH

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

 

[Sandy Mann]

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

 

[Guest]

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?

 

[Sandy Mann]

HTC,

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


Try:

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

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