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:
- Select the cell for the random value listing.
- Click on the button Insert Function /INSERT FUNCTION/
.
- STATISTICL Option in the dropdown menu.
- Select RANK function.
- OK button
- For the change in rankings open the cell.
- ORDERfield type 1 for the ascending order.
- OK button
- The end (Kraj).
|
Functions Index |