Excel Office Application: Six Ways to Rank by Achievement

2. Ranking function method (the most commonly used ranking function)

Analysis: RANK function is to find the ranking of a certain value in a certain area. The third parameter "0" indicates descending order, that is, the high-ranking one comes first and the low-ranking one comes last.

Excel Office Application: Six Ways to Rank by Achievement

3.COUNTIF function method (one of the four commonly used functions)

Analysis: COUNTIF function counts the number of values whose data area is greater than its own value, and then adds 1 to get the ranking.

Excel Office Application: Six Ways to Rank by Achievement

4.SUMPRODUCT function method (so-called "Almighty King" function)

Brief analysis: "$ B $ 2:$ B $7>；; B2 "Judge whether the value in the data area is greater than its own value. This function multiplies and accumulates the values corresponding to the array to get the number of people greater than its own value, and adds 1 to get the ranking.

Excel Office Application: Six Ways to Rank by Achievement

5. Comprehensive application of frequency and index function (favorite of office experts)

Analysis: The FREQUENCY function obtains the distribution frequency of "B2" in the data area, and the INDEX function extracts the number of values greater than "B2", and then adds 1 to get the ranking of "B2" values.

Excel Office Application: Six Ways to Rank by Achievement

6. Big+Match+Array Formula (the choice of office gods)

Analysis: The LARGE function sorts a column of data to generate an array, and then uses the MATCH function to get the sorted value of B2 in the array.

Difficulty: After entering the formula, press Ctrl+Shift+Enter to make it an array formula.