How excel uses the rank function to rank

There is a wonderful function "rank" in Excel, which can display the ranking of numbers in another column separately, and it can remove duplicate rankings. The result is that as many people are displayed. Let's share it with you, I hope it will be helpful to you.

Tools Raw materials.

Excel method steps.

1 4 Step by Step Reading.

In ordinary life, we want to sort a column of numbers, and the easiest thing for everyone to think of is to use the sort button, and then the next column is filled with the autofill function, but when two data are the same, the filled data can not show the ranking well. As you can see in the figure below, two 105s have the same score, but the autofill shows different rankings. We also had to manually modify the rankings of these same scores.

How can we let excel help us, without sorting shortcuts, and can remove duplicate rankings? First of all, we don't need to sort the data, go back to the original data form. As shown in the figure below:

The reporting system, the quick form software, is simpler than the excel server. Ad.

a$24)。where a2 is the data that needs to be determined, $a$2:$a$24 represents the data range, and the content in parentheses means that the data of A2 cells is in A2:

The ranking of the A24 data region will be displayed in cell B2. Figure 1 below shows the formula, and Figure 2 below shows the display of the calculation results.

See 1 image remaining.

Then select the B2 cell, place the mouse in the lower right corner, when the mouse becomes a small cross, press the left mouse button and pull down to the B24 cell, so that the ranking of all scores is displayed. As shown in the figure below:

Precautions. Note: When entering the data range, be sure to use the $ symbol, otherwise the ranking will be wrong.

Do you know how to use the rank function to rank in excel?

1. First of all, list the name and the grades of each subject in **, add a total score column and use the sum function to sum the operation.

2. Then click to the H2 cell and click "FX" to insert the function, and select the "Rank" function.

3. In the function parameter setting, set according to the parameters in the following figure, you need to add the "$" absolute reference symbol.

4. Click OK to generate the ranking result and pull down the formula to form the ranking of the corresponding total score.

5. Then select all the data cells and click "Custom Sort", and set them to be sorted in ascending order according to the ranking.

6. You can get a ranking table based on the total score, and show the corresponding name and the results of other subjects.

Click on the cell and select the rank function, enter the value you want to rank, select the reference range, and set the sorting method, the specific operation steps are as follows:

Tools Ingredients: ASUS Tianxuan 2, Windows10, Office20211, open the **file, and click the cell you want to display the calculation result.

3. Enter or select the numeric value you want to rank, and set the reference range to the data you want to find.

4. Enter a zero value or a non-zero value to determine the sorting method according to the actual situation, and then click OK.

Here's how to use the excel ranking function rank:

Tools Ingredients: HP P214, Windows 10, Excel20161, Open Excel**, enter some numbers as examples.

2. Then enter the formula "=rank(a2,$a$2:$a$10)" to calculate the ranking of A2 in the A2-A10 region.

3. Finally, press Enter to get the result, and then move the mouse to the lower right corner of the A2 cell, and pull down to see other rankings.

Excel uses the rank sub-formula as follows:

Tools: Dell K550, Win11, Excel2022 version.

1. First of all, list the name and the results of each subject in **, add a total score column, and use the sum function to sum or liquid monitoring.

2. Then click to the H2 cell and click "FX" to insert the function, and select the "Rank" function.

3. In the function parameter setting, set according to the parameters in the following figure, you need to add the "$" absolute reference symbol.

4. Click OK to generate the ranking result and pull down the formula to form the ranking corresponding to the total buried score.

5. Then select all the data cells and click "Custom Sort", and set them to be sorted in ascending order according to the ranking.

6. You can get the shirt and name list according to the total score, and show the corresponding name and other subject scores.

1. Take Excel2010 version as an example, as shown in the figure below, the total score of the column should be ranked;

2. First of all, enter the formula Bu Qi = Rank(G2,G:G) in the H2 cell, and the formula of the ruler slow Rank function is (the value of the ranking, the value area of the ranking), and press the Enter key after entering to get the ranking result;

3. Place the mouse in the lower right corner of the H2 cell, drop down and fill in the formula, and you can automatically arrange the total score of the column.

1. Open Excel and enter data in Excel.

2. Enter the data =rank() in the cell where you want to get the result.

3. Enter the cells participating in the ranking, the numerical region of the ranking and the sorting method in parentheses, 0 represents descending order, and 1 represents ascending order.

4. Press the enter key to get the corresponding results, and get the results of other cells according to the same method.

Ming or brigade 5, press alt+d+f+f to open the ranking column in ascending or descending order.

This article is based on the Dell Inspiron 5000 brand, Windows 10 system, Microsoft Office Excel 2019 version.