Ranking

In MS Excel we can know the sequence / stages to how a data from the smallest or the largest function RANK (Number; Ref: Order). For the last parameter (order), when its value = 0 it will be sorted in descending and when value <> 0 then be sorted in ascending

Syntax: RANK (number: ref; order)

number: the value of the selected
ref: Array
order: 1 for and 0 for Descending Ascending