Talk:Documentation/Calc Functions/RANK

    From The Document Foundation Wiki

    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)