SMALL Function question

[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....

 

[Harlan Grove]

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.

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.

 

[Monte Comeau]

Thanks!

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.