To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84476 Issue #|84476 Summary|RANK function with multiple ranges Component|Spreadsheet Version|OOo 2.3.1 RC1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|moravia
------- Additional comments from [EMAIL PROTECTED] Tue Dec 11 22:05:42 +0000 2007 ------- Received file created in MS Excel 2003 that has data in A2:A10 A12:A20 A22:A30. Then in B2 is =RANK(A2; (A2:A10,A12:A20,A22:A30), 1) which shows as Err:508 but works in Excel. The gaps are due to summary values in the other rows. Incidentally, if I remove the extra rows and make the formula =RANK(A2;A2:A200,1) I do not even get the right answer! (There is no number 1 rank; it starts at 3 and ends 2 higher than the number of entries.) --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]