<div class="raw-html-embed">	The RANK function is one of the <a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#statistical" onclick="onhyperlinkclick(this)">statistical functions</a>. It is used to return the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list (if you were to sort the list, the rank of the number would be its position).

	<h5 class="pt8">Syntax</h5>
	RANK(number, ref, [order])
	The RANK function has the following arguments:
	<table style="width: 40%">
		<tbody>
			<tr>
				<th style="background-color: #f4f4f4" width="150ch">Argument</th>
				<th style="background-color: #f4f4f4">Description</th>
			</tr>
			<tr>
				<td>number</td>
				<td>The value you want to find the rank for.</td>
			</tr>
			<tr>
				<td>ref</td>
				<td>The selected range of cells containing the specified number.</td>
			</tr>
			<tr>
				<td>order</td>
				<td>The numeric value that specifyes how to order the ref array. It is an optional argument. If it is 0 or omitted, the function ranks number as if ref were a list sorted in descending order. Any other numeric value is treated as the value 1 and the function ranks number as if ref were a list sorted in ascending order.</td>
			</tr>
		</tbody>
	</table>

	<h5 class="pt8">Notes</h5>
	<a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#howtoapplyfunctions_block" onclick="onhyperlinkclick(this)">How to apply</a> the RANK function.

	<h5 class="pt8">Examples</h5>
	The figure below displays the result returned by the RANK function.
	<img alt="RANK Function" src="https://static-helpcenter.teamlab.info/rank_b889fba569.png"></div>

RANK Function

Docs

Argument	Description
*number*	The value you want to find the rank for.
*ref*	The selected range of cells containing the specified *number*.
*order*	The numeric value that specifyes how to order the *ref* array. It is an optional argument. If it is 0 or omitted, the function ranks *number* as if *ref* were a list sorted in descending order. Any other numeric value is treated as the value 1 and the function ranks *number* as if *ref* were a list sorted in ascending order.

RANK Function

Syntax

Notes

Examples

Host ONLYOFFICE Docs on your own server or use it in the cloud