4 83 84 RANK Function 85 The ranking functions provides information with respect to a ranking of a specifically selected value relative to an array (or rang 86 Unlike the basic functions above, the ranking functions have a specific format in which the parameters need to be provided. 87 The RANK function returns the rank of a number within an range (array) of values. 88 It is ranked based on a descending order (largest value is ranked 1). + 89 In the box immediately below the formula '=RANK(2,490:191)' identifies the value 2 as the 4th smallest value in the range. 90 91 6 92 If the selected value was not a value in the range (e.g., 5) the RANK function would return an error. 93 94 We have used the RANK function to randomize questions and alternative answ to questions in the Workbooks. 95 The RAND function in the gray cells automatically generates random numbers. 96 Write a formula using the RANK function that ranks in the green cells the random numbers in the gray shaded cells. 97 Use the 's' to be able to copy the formula down. 98 99 100 0.4715 101 0.7853 102 0.5015 103 0.6493 104 105 Notice that every time you recalculate the Workbook (fn9 key) Excel regenerates the random numbers and the ranking sequence cha 106 107 PERCENTRANK Function 0.9939