Excell Formula help

  • Thread starter Thread starter TBD
  • Start date Start date
T

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
 
TBD said:
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
Click to expand...

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
 
Thanks Frank, It worked perfectly.

Frank said:
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
Click to expand...
 
Back
Top