About the use of Excel rank functions

The rank function is the rank function. The rank function is most commonly used to find the rank of a value in a region.

Rank function Syntax form: Rank (Number,ref,[order])

The number in the argument following the function name is the value or cell name (which must be a number in the cell) that requires ranking. Ref is ranked by the reference value area, order of 0 and 1, the default does not input, get from the big to small rankings, if you want to find the penultimate, the order of value please use 1.

Here's a few examples of rank functions:

Example 1: Positive ranking

In this case, we B2 cell 20 in the A1:a5 region of the ranking situation, we did not enter the order parameter, without entering the orders parameter, the default order value of 0, that is, from high to low sort. In this example, the 20 positive sort in the A1:a5 region is 1, so the result is 1.

Example 2: Inverted ranking

In this example, in the case of the example above, the order value is entered as 1, and the result is changed because the order value is 1, which means the reciprocal ranking, and 20 the A1:A5 in the region is 4.

Example 3: Find the ranking of a number of columns

In practical applications, we often need to ask for a list of values in a column, for example, we want to A1 to A5 cell data in their respective rankings. We can use the method of cell reference to rank: =rank (A1,A1:A5), this formula is to find A1 cell in A1:a5 cell ranking situation, when we use the automatic filling tool to drag data, we found that the result is wrong, carefully study, found that the A2 cell formula actually turned into = Rank (A2,A2:A6) This is beyond our expectation that the area of the data we are comparing is A1:A5 and cannot be changed, so we need to use the $ symbol to lock the formula A1:A2 the formula, so the formula for A1 cell becomes =rank (a1,a$1:a$5).

If you do not remember how this function is used, you can click "Insert" "function", the category Select "All", and then arbitrarily select a function name below, and then press the "R" button on the keyboard, you will soon find the rank function, the use of three parameters as described above.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join