LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Ranking sometimes shows ties and sometimes not

I calculate scores and rank the winners in a competition. The scores are a
total of points from different judges. Awards are given for the order of
finish. In the event of a tie, the awards are presented as for a tie. For
example, if two groups finish in second place with an identical score of
87.553, there should be two second place awards presented.

Sometimes the scores are identical, and the ranking displays them as
identical, which is what I want. However, at other times the calculated
scores are identical, and the ranking function ranks them - seemingly at
random. I opened up the decimal places and cannot find any differences
between the two scores, yet the ranking function ranks them. This can cause
the awards to be presented incorrectly, as the presenter, if not careful, may
not notice that the scores are identical, but instead see the ranking which
does not show them as identical.

I would like identical scores to be displayed as identical. Any suggestions
on how to achieve this? The scores range from 1 to 100 with 3 decimal places
displayed.
--
RJQ
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to rank values with ties MichaelZ Excel Worksheet Functions 9 September 22nd 08 05:44 PM
Rank without skipping for ties John Michl Excel Worksheet Functions 0 March 6th 08 04:27 PM
Ranking question (ties) rozeltf Excel Discussion (Misc queries) 5 April 8th 06 05:25 PM
Changing percentrank ties nesser522 Excel Discussion (Misc queries) 1 July 27th 05 12:20 AM
Ranking of cells from 1 to 20 with ties Xanadude Excel Worksheet Functions 4 May 29th 05 01:32 AM


All times are GMT +1. The time now is 03:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"