John Viestenz wrote:
----- Original Message ----- From: "Terry Woodhouse"
<[EMAIL PROTECTED]>
Subject: [users] spreadsheet function malfunction - RANK
Hi users,
I'm using OOO v1.1.4, my system is Windows XP Home ed.
I came across an apparent malfunctioning spreadsheet function,
RANK. I tested it first with a small series of 15 figures,
1 2 3 3 3 4 5 6 7 8 9 9 10 10 10, & the rank TYPE = 0 (ascending),
& it produced a series from 32 to 1, i.e. the first figure in the
series (1)
was ranked as 32, the second figure (2) was ranked as 31, & so on.
When I changed the rank TYPE = 1 (descending), all the figures were
ranked as 1.
When I reversed the order of the figures, then the opposite happened!
I hope I'm not showing my ignorance, I'm not a mathematician but
something seems wrong here.
Can anyone enlighten me please?
--
cheers,
Terry mailto:[EMAIL PROTECTED]
I do not see the same results as you indicated. I, too, am not a
mathematician, and have not used the RANK function before, so....
but if I enter the sequence of numbers you indicated, each in a separate
cell, then enter a formula in the form of =RANK(2;C4:C18;0), where
C4:C18 is the range of cells that contain the sequence, I get 14. The
value 2 is the 14th in rank, from the "top". Changing the type from 0
to 1, I get "2" as the answer: the value 2 is now the 2nd in rank.
Yes, I would first expect 0 (ascending) and 1 (descending) would give
the opposite of the results obtained, but I don't see the problem you
described (getting a "32" ranking when you only had 15 elements; or
getting all the figures ranked as "1").
There is an error in function description. 0 or omitted means
descending, 1 or any other value - ascending.
I filed issues against spreadsheet and documentation component, you can
vote if you wish.
http://qa.openoffice.org/issues/show_bug.cgi?id=54231
http://qa.openoffice.org/issues/show_bug.cgi?id=54232
ain
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
