Formula Question
 

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 ?

and if two or more golfers have the same score?...?
--
Gary''s Student


"HTC" wrote:

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

Replace@mailinator with @tiscali.co.uk


"HTC" wrote in message
...
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 ?

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

Good thinking, I never thought of that!

--
Regards

Sandy

Replace@mailinator with @tiscali.co.uk

"Gary''s Student" wrote in message
...
and if two or more golfers have the same score?...?
--
Gary''s Student


"HTC" wrote:

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 ?

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" wrote:

Try:

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

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"HTC" wrote in message
...
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 ?

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,M ATCH(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

Replace@mailinator with @tiscali.co.uk

"HTC" wrote in message
...
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" wrote:

Try:

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

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"HTC" wrote in message
...
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
?