Issue 118026

Summary: Option for RANK function to issue sequential numbers on duplicates
Product: Calc Reporter: cheros <phobos>
Component: programmingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: elish, issues
Version: OOo 3.3   
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Description cheros 2011-05-16 07:54:33 UTC
When the RANK function is presented with a series of numbers with duplicates, it skips a rank when producing a duplicate RANK, i.e. ranking the numbers (10, 9, 8, 8, 7, 7) results in (1, 2, 3, 3, 5, 5).

I realise that this behaviour is kept compatible with Excel, but it would be great if RANK could be given a flag so it does not SKIP a rank when handling duplicates, i.e. the series above would yield a result of (1, 2, 3, 3, 4, 4).  As for a simple reason why you'd want this - ever seen footballs scores skip a rank?  It almost seems incorrect just for compatibilities' sake, but I'm admittedly not a mathematician.

I know that both Microsoft and OOo publish "fixes" for the duplicates situation, but those fixes remove the duplicate ranking instead of addressing the skip that duplicates currently create.  Worse, they subject the results to the vagaries of internal rounding..

Thank you for your time.
Comment 1 Oliver-Rainer Wittmann 2012-06-13 12:19:02 UTC
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.
Comment 2 Edwin Sharp 2013-12-26 20:06:51 UTC
Useful enhancement.
Excel 2010 has RANK.AVG and RANK.EQ which IMHO are inferior to a continuous ranking as suggested by the author.