SMALL Function question

  • Thread starter Thread starter Monte Comeau
  • Start date Start date
M

Monte Comeau

Hi All,

First off, many thanks that assisted me in getting my golf score sheet
running properly with the MATCH & INDEX stuff...it works great.

I have a problem with the SMALL function...I have a list of 5 lowest scores
returned from a range called 'calcutta'. In the adjacent cell I have the
coresponding name returned ato match the score with the player. The problem
is with ties. If two players hve the same score the SMALL function returns
the first one it finds in each cell.

I use it like this

G1=SMALL(CALCUTTA,1)
G2=SMALL(CALCUTTA,2)

ETC....
 
Monte Comeau said:
I have a problem with the SMALL function...I have a list of 5 lowest scores
returned from a range called 'calcutta'. In the adjacent cell I have the
coresponding name returned ato match the score with the player. The problem
is with ties. If two players hve the same score the SMALL function returns
the first one it finds in each cell.
Click to expand...

If you need to list all players, you need to add something to the scores in
order to distinguish tie scores. For example, if CALCUTTA were a single
column, multiple row range, add the row number divided by 100000 or other
large number that would ensure the scaled row number was smaller than the
smallest possible difference in scores. Then use

=SMALL(CALCUTTA+ROW(CALCUTTA)/100000,N)

to find the player with the N_th lowest score.
 
Thanks!

Harlan Grove said:
If you need to list all players, you need to add something to the scores in
order to distinguish tie scores. For example, if CALCUTTA were a single
column, multiple row range, add the row number divided by 100000 or other
large number that would ensure the scaled row number was smaller than the
smallest possible difference in scores. Then use

=SMALL(CALCUTTA+ROW(CALCUTTA)/100000,N)

to find the player with the N_th lowest score.
Click to expand...
 
Back
Top