How to use the rank function in Excel to avoid repeated rankings. Tutorial on using the rank function in Excel tables

Excel tables are software that many users use when working. When ranking through tables, many duplicate rankings appear. Then we can use the rank function to perform non-duplicate rankings, but many friends do not know rank. How to use functions, in response to this problem, today's software tutorial will share detailed operation steps for the majority of users. Friends in need are welcome to check out the relevant methods on the PHP Chinese website. How to use the rank function in Excel to avoid repeated rankings 1. First open the table and enter your table.

2. Then enter the formula in the cell: =RANK(H2, H2:H47, 0) to see the ranking of 43 in the first row.

3. Then place the book in the lower right corner of the cell and pull it down.

4. In the end, you can see a lot of repeated rankings, but there are no second and third places.

5. If you need no repetition, you need to add the formula to rank: =RANK (H2, $H$2: $H$47, 0) + COUNTIF ($H$2: $H2, H2) -1 to avoid repetition.

The above is the detailed content of How to use the rank function in Excel to avoid repeated rankings. Tutorial on using the rank function in Excel tables. For more information, please follow other related articles on the PHP Chinese website!