Your range is moved as well : =RANK(B5;B5:B8) should be =RANK(B5;B2:B5) Met vriendelijke groeten, Salutations distinguées, Kind Regards, DRIES FEYS CORPORATE SERVICES • Specialist Software Developer TVH GROUP NV Brabantstraat 15 • BE-8790 WAREGEM T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com On 13 November 2013 13:38, minhsien0330 <minhsien0330@gmail.com> wrote:
Dear all: I want rank some score. There are 4 scores : 92.6, 93.6, 98.2 and 95.2 It's strange that the function "RANK() " rank 95.2 as "no. 1" You can download this ods file to test: https://sites.google.com/site/minhsien0330/test/RANK_PROBLEM.ods?attredirects=0&d=1 Is this a bug? Thank you~ Regards Minhsien0330 -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
-- **** DISCLAIMER **** http://www.tvh.com/newen2/emaildisclaimer/default.html "This message is delivered to all addressees subject to the conditions set forth in the attached disclaimer, which is an integral part of this message." -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted