EXCEL

  • Thread starter Thread starter Corky
  • Start date Start date
C

Corky

How do I determine the lowest number in a column and also
determine if it is the only number that is of that value.
I'm trying to set up a spreadsheet for a golf skins game
where it is 2 tie all tie.
 
To return the smallest number in a range:
In cell say A102

=MIN(A1:A100)

To count the occurences of this number:
In cell say A103

=COUNTIF(A1:A100,A102)

Alby
 
How about:

=MIN(A1:A23)
and
=COUNTIF(A1:A23,MIN(A1:A23))

You may want to take a look at the =small() function in help--if you ever need
the 2nd smallest one. (and there's an =large(), too!)
 
and an =max(), too!

(should have added that.)
How do I determine the lowest number in a column and also
determine if it is the only number that is of that value.
I'm trying to set up a spreadsheet for a golf skins game
where it is 2 tie all tie.
Click to expand...
 
Back
Top