Talk:Documentation/Calc Functions/RANK

SF comments

 * (1) Summary. Suggest the following expanded text – “Calculates the rank of a given value within a supplied list of numbers. The rank of a number is its size relative to other values in the list; this means that if you sort the list, a number’s rank is its position within the sorted list.”.
 * (2) Returns. It might be worth saying that the value returned is in the range 1 to the number of elements in the specified list of numbers.
 * (3) Returns. The comma in this sentence appears to be unnecessary.
 * (4) Arguments, Value. The comma in this sentence appears to be unnecessary.
 * (5) Arguments, Type. Suggest changing “range” to “array” for consistency.
 * (6) Arguments, 1st bullet. I think the approach taken for duplicates should be made clearer - it seems vital to understanding differences between RANK, RANK.EQ and RANK.AVG. I don't feel that the explanation inherited from the ODF is as clear as it could be.
 * (7) Arguments, 2nd bullet. In “If Value”, should “Value” be in bold? Insert space before “(#VALUE!)”.
 * (8) Arguments, general. What happens if Type contains something other than 0 or 1? What happens if the contents of Value or Data are not real numbers?
 * (9) Examples, 3rd example. Insert space before “(default”.
 * (10) Examples, general. Don’t we normally provide examples of error conditions?
 * (11) General. Should this page identify differences from RANK.AVG and RANK.EQ?

--Stevefanning (talk) 2020-11-04T16:10:56 (UTC)

Ronnie
all points addressed. --Ronnie rg8888 (talk) 2020-11-28T18:23:12 (UTC)