Apache OpenOffice (AOO) Bugzilla – Issue 118026
Option for RANK function to issue sequential numbers on duplicates
Last modified: 2013-12-26 20:06:51 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.
getting rid of value "enhancement" for field "severity". For enhancement the field "issue type" shall be used.
Useful enhancement. Excel 2010 has RANK.AVG and RANK.EQ which IMHO are inferior to a continuous ranking as suggested by the author.