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.
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
https://bugs.documentfoundation.org/show_bug.cgi?id=158258
ady changed:
What|Removed |Added
Resolution|--- |NOTABUG
Status|NEEDINFO
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.
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:
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
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.
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.
https://bugs.documentfoundation.org/show_bug.cgi?id=158258
ady changed:
What|Removed |Added
Status|UNCONFIRMED |NEEDINFO
Ever confirmed|0