Excell Formula help

[TBD]

I have a group of columns that I would like to pull the lowest number in
each column to show up at the bottom if it is the only lowest number.
To explain it better, it is for a golf skin game, each player is listed
in column A then the holes are listed in columns B thru S. I would just
like to have the lowest score (per column) entered in the last row, with
no entry if there is a tie. Thanks in advance

 

[Frank Kabel]

I have a group of columns that I would like to pull the lowest number
in each column to show up at the bottom if it is the only lowest
number. To explain it better, it is for a golf skin game, each player
is listed in column A then the holes are listed in columns B thru S.
I would just like to have the lowest score (per column) entered in
the last row, with no entry if there is a tie. Thanks in advance

Hi
to get the lowest score use
=MIN(B1:B10)
if you want to have a blank cell, if there is a tie try
=IF(COUNTIF(B1:B10,MIN(B1:B10))>1,"",MIN(B1:B10))

HTH
Frank

 

[TBD]

Thanks Frank, It worked perfectly.

Hi
to get the lowest score use
=MIN(B1:B10)
if you want to have a blank cell, if there is a tie try
=IF(COUNTIF(B1:B10,MIN(B1:B10))>1,"",MIN(B1:B10))

HTH
Frank

 

[Frank Kabel]

Hi
thanks for the feedback
Frank

Thanks Frank, It worked perfectly.