abc MICROSOFT EXCEL 2010 - Functions
Order of values by descending order /RANK/

Function RANK assigns ordinal numbers to the /SELECTED/ values. ORDER field decides on descending (Value 0 or empty) ascending (Value 1). Function RANK is a statistical function.


Picture 1. order of values by descending order /RANK/

Order of values by descending order /RANK/, steps:

  1. Select the cell for the random value listing.
  2. Click on the button Insert Function /INSERT FUNCTION/ .
  3. STATISTICL Option in the dropdown menu.
  4. Select RANK function.
  5. OK button
  6. For the change in rankings open the cell.
  7. In the ORDER field type in 0 or empty for the descending order.
  8. OK button
  9. The end (Kraj).

Functions    Index