Can't get rank to work correctly

  • Thread starter Thread starter Peter Balcombe
  • Start date Start date
P

Peter Balcombe

I have produced a very simple spreadsheet to keep the scores for "Quiz and
Chips Evenings". The spreadsheet simply totals the scores for each of up
twenty teams (tables) of participants. There is provision for up to 10
normal "rounds" and one generously timed "table round". The spreadsheet is
used to tell participants at the end of each round and at the end of the
full contest their total score. I wish to use "Rank" to advise which team is
first, second etc but am having difficulties particularly in that for some
reason different scores are producing the same ranking. I am also wanting to
find a way of avoiding ranking any unoccupied (i.e. zero scoring) "tables".

Can anyone please advise where I might be going wrong?
 
How can anyone advise you Peter, if they don't know what you're doing ?

Would need to see what your formula looks like, and examples of your data.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

I have produced a very simple spreadsheet to keep the scores for "Quiz and
Chips Evenings". The spreadsheet simply totals the scores for each of up
twenty teams (tables) of participants. There is provision for up to 10
normal "rounds" and one generously timed "table round". The spreadsheet is
used to tell participants at the end of each round and at the end of the
full contest their total score. I wish to use "Rank" to advise which team is
first, second etc but am having difficulties particularly in that for some
reason different scores are producing the same ranking. I am also wanting to
find a way of avoiding ranking any unoccupied (i.e. zero scoring) "tables".

Can anyone please advise where I might be going wrong?
 
RagDyer said:
How can anyone advise you Peter, if they don't know what you're doing ?

Would need to see what your formula looks like, and examples of your data.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

I have produced a very simple spreadsheet to keep the scores for "Quiz and
Chips Evenings". The spreadsheet simply totals the scores for each of up
twenty teams (tables) of participants. There is provision for up to 10
normal "rounds" and one generously timed "table round". The spreadsheet is
used to tell participants at the end of each round and at the end of the
full contest their total score. I wish to use "Rank" to advise which team is
first, second etc but am having difficulties particularly in that for some
reason different scores are producing the same ranking. I am also wanting to
find a way of avoiding ranking any unoccupied (i.e. zero scoring) "tables".

Can anyone please advise where I might be going wrong?


Probably fair comment - I'll have a go as follows: -
Click to expand...

Entries in earlier columns on my spreadsheet have produced a column of
totals. The individual totals in the column change as further entries are
made in the preceding columns. I want to add a new column which ranks the
the totals such that the highest total is number 1 the next highest 2 and so
on but which ignores any totals which are zero. The latter represent non
existent quiz teams. At present the formula I am using for the ranking
column is "=RANK(N7,N7:N26,1)" , "=RANK(N8,N7:N26,1)" ......etc
 
With a bit of additional work I have discovered my errors - in copying the
formula an error has been introduced through Excel automatically updating
the the reference range when it needs to remain constant. Also of course the
"1" should become"0" to get an ascending rank. My one remaining problem -
how to get totals of zero ignored - at present they are correctly but
unwantedly showing as the (equal) lowest total. Any suggestions?
 
Back
Top