RANK Excel Formula

Author Zaheer    Category Formulas     Tags ,

Microsoft Excel is such a prevailing software included in Microsoft Office. It allows you to manipulate data, create graphs of the given values, and compute with the use of formulas and pre-installed functions. The functions in Excel are used in different fields such as engineering, text, data base, math, statistical, and a lot more. For the convenience of the user, these functions are subdivided into groups as to its uses and kinds. For the Statistical Function it is sub-grouped into counting cells functions, averages, frequency and rank function, and others.

Statistical Function allows you to do tasks such as finding mean, median, and mode to the more complex calculations such as statistical distribution. However, for the earlier version of Excel few of the functions are not yet pre-installed. Included in the Statistic Function is known as Rank function. This kind function allows you to rank a given value in range of values. The syntax of RANK function include:


…whereas the argument Number actually refers in the value that you would like to find out the rank. The Ref argument refers to value or reference cells of value and if the values in nonnumeric then the argument will not be included. For Order argument, it refers to specified number which how the value is ranked.

If orders in the syntax is deleted then the Excel ranks the numbers in a descending order. When the order is greater than zero then the list will be arranged in an ascending orders.

RANK will give similar number the same ranks however, if there are duplicated values it will then affect the succeeding values.

For example if you have the following data in this following cell such as; cell A1 with the data 7, cell A2 with the data 3.5, cell A3 with the data 3.5, cell A4 input the data 1, and in cell A5 input the data 2. For the formula, input the function =RANK(A2,A1:A5,1) and the result will be 3 with ranks 3.5 on a given values.

The #N/A error will occur if the given values are not included in the variety of data or values.

Post comment