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

Function RANK ordinal numbers in the list of the selected /SELECTED/ values. Function RANK is a statistical function.


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

Order of values by ascending 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. ORDERfield type 1 for the ascending order.
  8. OK button
  9. The end (Kraj).

Functions    Index