- Picture and text skills
- Case
Returns the numerical ranking of a list of numbers: the ranking of a number is the ratio of its size to other values in the list;
If multiple values have the same rank, the average rank will be returned.
Grammar
RANK.AVG(number,ref,[order])
RANK.AVG function syntax has the following parameters:
Number Required. The number whose ranking is to be found.
Ref Required. Array of lists of numbers, a reference to a list of numbers. Non-numeric values in Ref are ignored.
Order Optional. A number that specifies how the numbers are ranked.
Description
If Order is 0 (zero) or omitted, Excel ranks the numbers based on ref being a list in descending order.
If Order is non-zero, Excel ranks the numbers based on ref being a list in ascending order.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/RANK-AVG-han-shu-de-shi-yong-fang-fa.html
评论列表(196条)
测试