(9) How to use RANK formula in Microsoft Excel.
RANK: RANK Function returns 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.
=RANK(number,Ref,[order])
Example:
Give the formula in B11 cell.
| Formula |
Description |
Result |
| =RANK(B10,B2:B10,1) |
Returns the smallest number in a set of values.
here,B10=85, RANGE=B2:B10, 1=Ascending order. IF you want descending order give 0 into 1. |
5
|
Video:
How to use RANK formula in Microsoft Excel:
|