How to use the rank function in excel How to use the rank function in excel

Excel is often used in our daily work. How to use the rank function in Excel? The rank function is a ranking function, which is to find the ranking of a certain value in a certain area. Many friends still don’t know how to use the rank function in excel, so the editor below explains how to use the rank function in excel. Setting method 1. Open the Excel file that needs to be sorted (as shown in the figure).

2. Enter =RANK (A1, A1:A7) in cell B2, click √ above (you can also press the Enter key), this is to limit the range where the function is to be used, and you can get the ranking of the cell (As shown in the picture). fenye3. If you need to get the value of the drop-down function, you need to add absolute reference symbols to A1:A7 of the function =RANK (A1, A1:A7). When using the fill formula, fill it down, and the next formula will automatically become A2, if it goes to the right, it will automatically become B1 (as shown in the picture).

4. Finally, use the drop-down function to get all rankings (as shown in the picture).

The above is the detailed content of How to use the rank function in excel How to use the rank function in excel. For more information, please follow other related articles on the PHP Chinese website!