Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
1, a numerical value in a ranking of the function RANK Numerical data on the ranking list with the relative size of other values, of course, if the data list has been ranked the sequence, then the value of the current ranking is its location. Data can be used to sort the list of Excel functions provided by the completion of sequencing. Grammatical form of RANK (number, ref, order) One Number for the need to find the number of qualifying; Ref for the array contains a set of figures or references. Order for a number of ways to specify the ranking. If the order is 0 or omitted, then Excel will ref as the data in descending order according to the list of qualifying. If the order is not zero, Microsoft Excel will be ref as the data in ascending order according to the list of qualifying. It is RANK function to repeat the same number of qualifying. However, the existence of duplication of the number of follow-up will affect the ranking values. Ah, it seems to parallel the concept of the first few ah. For example, in an integer, if an integer 10 appears twice, the ranking of 5, then 11 qualifying for the 7 (not ranking the value of 6). 2, for specific numerical data in a function of the percentage of qualifying PERCENTRANK PERCENTRANK this function can be used to view the specific data in the data location. For example, you can use the calculation function PERCENTRANK the ability of a particular test of the ability to score in all of the location of the test scores. Grammatical form of PERCENTRANK (array, x, significance) One Array to determine the relative position between the number of the array or the number of regions. X for the array needs to be the value of their ranking. Significance is optional, that the percentage of the value of the return of the median effective. If omitted, function to retain three decimal PERCENTRANK. 3, with the rank of the sample Still a year-end bonus distribution of units as an example, where Annie's ranking employees as an example of the wording of the formula. Top prize for writing the formula: = RANK (C3, $ C $ 3: $ C $ 12) Written formula for ranking the percentage for: = PERCENTRANK ($ C $ 3: $ C $ 12, C3)
|
