HomeApplicationOffice information

How to use the RANK function in Excel

The Rank function in Excel is a function used by many people in data processing. For accountants, the Rank function is very popular.

Those who are new to Excel functions may not know the syntax and usage of the Rank function. The following article describes the function, syntax and usage of the Rank function in Excel.

Description

The Rank function returns the rank of a number in a list of numbers, the rank of a number is its value rank compared to other values ​​in the list of numbers. It is similar to data sorting but has superior results and is easier to manage.

Syntax

RANK (number, ref, [order])

Inside:

- number: the number you want to find the rank.

- ref: array or reference to a list of numbers, if the value is not a number, it will be ignored.

- order: sort order (ascending or descending). If the order is 0 (or no parameters) then the result will be sorted descending. If the order is 1 or any value other than 0, the result will be ascending.

For example

For the following data sheet, a ranking of employees is required based on the number of products sold. The employee who sells the most products will rank first.

How to use the RANK function in Excel Picture 1

First, you need to write the RANK function formula for the ranking cell in cell F5:

= RANK (E5, E5: E11,0)

Inside:

E5 is the number to find (rank of product sold by the first employee).

E5: E11 is a list of numbers (in the example, a list of products sold by all employees who need to be ranked).

0 is sorted in ascending order (the highest number of products sold will rank as 1).

The following results:

How to use the RANK function in Excel Picture 2

Enter the formula with the remaining cells, replace the number to find the rank corresponding to the formula position and keep the list of numbers and sort order. The result will get the following:

How to use the RANK function in Excel Picture 3

With identical numbers there will be equal rank but affect the rank after it. For example, the number 15 appears twice and has a rank of 6, then the number 16 will have a rank of 8 (no number with a rank of 7). So, you already know the function, syntax and usage of the Excel Rank function. To understand and master the Rank function, you need to use the Rank function more often. Good luck!

4 ★ | 2 Vote

You should read it

May be interested

  • How to use Hlookup function on ExcelHow to use Hlookup function on Excel
    hlookup function basically also has the function syntax and features like vlookup function, which is to help users find data in excel table, with the conditions or given information. here is the guide for using the hlookup function in detail.
  • How to use the SUM function to calculate totals in ExcelHow to use the SUM function to calculate totals in Excel
    sum is a popular and very useful excel function, and is also a basic arithmetic function. as its name suggests, the sum function is used to calculate totals in excel. and the parameters can be single parameters or ranges of cells. in this article, tipsmake.com will guide you to use the sum function to calculate the sum in excel, the common errors when calculating sum by sum and how to fix it.
  • How to use the LEN function in ExcelHow to use the LEN function in Excel
    the len function in excel is used to measure the length of a certain string of characters, including spaces and correctly return the total character for the user.
  • How to use COUNTIF function on ExcelHow to use COUNTIF function on Excel
    the countif function on excel is the cell count function to satisfy the given condition, often used in statistics tables.
  • How to use the MOD function and QUOTIENT function in ExcelHow to use the MOD function and QUOTIENT function in Excel
    injury in excel has many ways of doing it, can be used manually or using the calculation function.
  • 8 little-known Excel functions that can save you a lot of work8 little-known Excel functions that can save you a lot of work
    even seasoned excel users often find themselves stuck performing tasks manually that could be automated with a few clever functions.
  • How to use MID functions to get strings in ExcelHow to use MID functions to get strings in Excel
    mid function in excel is a function that takes the middle character string corresponding to the value that the user requires to perform.
  • How to use Excel's VALUE functionHow to use Excel's VALUE function
    excel's value function will convert a string to a digital form, which can be combined with other functions such as left function, right function, mid function.
  • How to use the WRAPROWS function in ExcelHow to use the WRAPROWS function in Excel
    having trouble with handling large data sets in excel? then learn how to use the wraprows function to split them into more manageable rows.
  • How to use the IFS function in Excel 2016How to use the IFS function in Excel 2016
    the ifs function in excel is a logical function introduced in excel 2016. this function is a function that replaces the nested if function and is much easier to use. the ifs function checks one or more conditions and returns a value that meets the first true condition.

Office information