[Libreoffice-bugs] [Bug 158258] Rank Function not working
https://bugs.documentfoundation.org/show_bug.cgi?id=158258 --- Comment #9 from GyleMc --- THANK YOU ady! Adding the value in f20~ to the rank values is exactly what I needed. The IF() functions can be eliminated as they were in case the value was lower or higher than the existing ten numbers. Now that the value is included in the range it returns the 1 or 11 as needed. This simplifies the formula greatly and again, thank you for this solution!! -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 158258] Rank Function not working
https://bugs.documentfoundation.org/show_bug.cgi?id=158258 --- Comment #8 from ady --- This comment is off-topic regarding the report itself, but it may help users in search for similar needs regarding the function/formula. Generally speaking, when the searched-for value is not included in the original data, a possible solution could be to add such value to the referenced data. *BEWARE*: this is not a solution for every case, and it can also have negative consequences. This is only a hint, and you are responsible for adapting the formula to your needs and for reviewing the results when the additional value is either: _ lower than the data _ higher than the data _ in-between the min and max values in data _ included in the data _ invalid _ the rank is sorted in the opposite direction (ascending vs. descending). Taking attachment 190906 as example: >From the original formula in cell G20: =IF(F20>MAX(INDEX($O$4:$X$15;MATCH(EOMONTH(A20;0)-C20+1;$A$4:$A$15;0)));1;IF(F20MAX(INDEX($O$4:$X$15;MATCH(EOMONTH(A20;0)-C20+1;$A$4:$A$15;0)));1;IF(F20
[Libreoffice-bugs] [Bug 158258] Rank Function not working
https://bugs.documentfoundation.org/show_bug.cgi?id=158258 ady changed: What|Removed |Added Resolution|--- |NOTABUG Status|NEEDINFO|RESOLVED --- Comment #7 from ady --- To simplify the problem... You are searching the RANK() of the numeric value 647 within the data: 682 657 654 645 636 632 612 559 533 500 from higher to lower values. Until LO 7.5.3, the result would be indeed 4, which is incorrect; the value 647 is not really included in the data. That's incorrect according to the ODFF definition of RANK(), so the function was corrected for LO 7.5.3. I would suggest searching for an alternative way (i.e. modified formula) that would correctly calculate the result you want. Or perhaps the corrected RANK() result is what you actually need? Maybe someone at the users mailing list or at https://ask.libreoffice.org might be able to help with that. Either way, this report is Not A Bug. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 158258] Rank Function not working
https://bugs.documentfoundation.org/show_bug.cgi?id=158258 --- Comment #6 from GyleMc --- Don't see the note so I'll try again: The formula in question is on page "24 SREC" Cell G20 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 158258] Rank Function not working
https://bugs.documentfoundation.org/show_bug.cgi?id=158258 --- Comment #5 from GyleMc --- Created attachment 190906 --> https://bugs.documentfoundation.org/attachment.cgi?id=190906=edit Worksheet in question The formula is on page "24 SREC" cell g20 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 158258] Rank Function not working
https://bugs.documentfoundation.org/show_bug.cgi?id=158258 --- Comment #4 from GyleMc --- (In reply to ady from comment #1) > The RANK() function was indeed corrected for LO 7.5.3. > > Please use the "Add an attachment" link to add a sample file. Please be > aware that it will be publicly available, so you might want to read > > https://wiki.documentfoundation.org/QA/Bugzilla/ > Sanitizing_Files_Before_Submission > > before attaching it. I will attach the file. The formula in question was cleaned up (simplified) thanks to Werner Tietz, but still does not work in the newer version. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 158258] Rank Function not working
https://bugs.documentfoundation.org/show_bug.cgi?id=158258 --- Comment #3 from GyleMc --- Thanks, that is a much cleaner formula. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 158258] Rank Function not working
https://bugs.documentfoundation.org/show_bug.cgi?id=158258 --- Comment #2 from Werner Tietz --- Hallo off topic: Why not: =RANK(F20,INDEX($O$4:$X$15;MATCH(EOMONTH(A20,0)-C20+1;$A$4:$A$15;0)) -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 158258] Rank Function not working
https://bugs.documentfoundation.org/show_bug.cgi?id=158258 ady changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #1 from ady --- The RANK() function was indeed corrected for LO 7.5.3. Please use the "Add an attachment" link to add a sample file. Please be aware that it will be publicly available, so you might want to read https://wiki.documentfoundation.org/QA/Bugzilla/Sanitizing_Files_Before_Submission before attaching it. -- You are receiving this mail because: You are the assignee for the bug.
