Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenFri, 21 Sep 2018 16:22:34 +0200Rank : how to prevent duplicateshttps://ask.libreoffice.org/en/question/166342/rank-how-to-prevent-duplicates/=RANK(T5,$T$5:$T$43,0)
How do I fix so I do not have duplicates.
thank you for any help anyone provides JG101Fri, 21 Sep 2018 16:22:34 +0200https://ask.libreoffice.org/en/question/166342/Is there a list of openCL functions for calc? Can a function be added?https://ask.libreoffice.org/en/question/101263/is-there-a-list-of-opencl-functions-for-calc-can-a-function-be-added/Specifically, I have used only 2 simple functions rand() and rank (4500x2 array) and I get no GPU acceleration or usage at all. First, I generated a 4500x1 array of rand() numbers and then used another column to rank those random numbers. OpenCL works correctly, as I have downloaded the test spreadsheet "BuildingDesign" and get the proper results with significant GPU usage during test.FreemanSun, 18 Jun 2017 22:36:01 +0200https://ask.libreoffice.org/en/question/101263/Rank (where do I put the ",1"https://ask.libreoffice.org/en/question/78544/rank-where-do-i-put-the-1/(Edited for better readabiliy; Lupp)
*(The formula below should be entered for evaluation in array-mode.)*
`=IF(JC11=0;"";RANK(JC11;IF($JC$11:$JC$100>0;$JC$11:$JC$100;1))+COUNTIF($JC$11:$JC$11;$JC$100)-0)`
I found this on the net, works great. One thing, I need it reverse order
show smallest to equal "1" not max equal "1".
where do I put the ",1" or how can it be changed to show Rank smallest to max
(i've tried several scenario's nothing seems to work)
thank you in advance for any help provided.JG101Sun, 02 Oct 2016 22:34:18 +0200https://ask.libreoffice.org/en/question/78544/Rank two columns ?https://ask.libreoffice.org/en/question/76654/rank-two-columns/see attached document [Rank Two Columns 09-05-2016 2.ods](/upfiles/14731298266855374.ods)
Rank Column B and Column E Lowest number equals = 1 , Highest number equals = 32 or highest number available given duplicate OA numbers
example:
Row 5 Column B 1 Column E 5
Row 6 Column B 10 Column E 9
I would like to Rank two columns
should read by Rank
Rank 1 Row 5 Column B
Rank 2 Row 5 Column E
Rank 3 Row 6 Column E
Rank 4 Row 6 Column B
thank you in advance for any help provided.
How do I write, =ifna(rank(???? or =iferror(rank(?????JG101Tue, 06 Sep 2016 02:28:50 +0200https://ask.libreoffice.org/en/question/76654/=Rank #value! (remove)https://ask.libreoffice.org/en/question/73680/rank-value-remove/original - but returns #value!
=RANK(I16,$I$16:$I$313,0)
I would like it to return a blank instead of #value! how do I fix this function.
=IFNA(RANK(I16,$I$16:$I$313,0),"")
thank you in advance for any help.JG101Thu, 21 Jul 2016 04:57:25 +0200https://ask.libreoffice.org/en/question/73680/How do I replace all spreadsheet values with their RANK?https://ask.libreoffice.org/en/question/37135/how-do-i-replace-all-spreadsheet-values-with-their-rank/I'm using the latest Calc with Ubuntu 14.04. How can I replace all values with their RANK, given about 9238 values? Any feedback is appreciated; I'll continue to look for a solution. The data can be found here: https://drive.google.com/?tab=mo&authuser=0#folders/0B3fa1Bco9n2EWk5vdTZiLWZRaUkshawn.1671Thu, 17 Jul 2014 16:03:05 +0200https://ask.libreoffice.org/en/question/37135/Rank function misbehaving with time valueshttps://ask.libreoffice.org/en/question/22063/rank-function-misbehaving-with-time-values/I'm trying to rank split times from a marathon, but the RANK() function does not give equal rank to equal times. I've tried feeding the function absolute times (e.g. 18:15) and it works fine, but not when fed a calculated time (e.g. 15k time minus 10k time). Any thoughts.Clack ValveSun, 01 Sep 2013 00:18:23 +0200https://ask.libreoffice.org/en/question/22063/