From The Document Foundation Wiki
- (1) General. RANK.AVG has much commonality with RANK. Please update this page to reflect relevant comments raised on the RANK page.
: (2) General. I think it would be helpful to clarify what “If there are duplicate values in the list, the average rank is returned” really means.