Function Performed: Ranking
Number of Arguments: One member or existing calculation
Options: Ascending or descending (the default). If ascending, the smallest value is ranked as 1. If descending, the largest value is ranked as 1.
Example: Consider a spreadsheet with Actual as a column, Jan, Feb, Mar as rows, and Actual values of 100, 300, 600. If descending is selected, Rank values are 3, 2, 1. If ascending is selected, Rank values are 1, 2, 3.