Excel Uses Rank Sub-Ranking Formula? Excel is a commonly used office software when we work, used to process all kinds of data and **, there are many formulas on it that can be used for calculations. Sometimes there are too many data, and if you want to sort these data, you can use the rank formula to rank the second, and many friends don't know how to operate. So today, I will tell you how Excel uses the rank ranking formula, including ascending and descending. Get started with the Excel tutorial
Excel Uses Rank Sub-Ranking Formula?
1. First of all, we open the excel** that needs to be sorted;
2. Enter the formula in cell C1:=rank()
3. Enter the cells participating in the ranking, the numerical range of the ranking and the sorting method in parentheses, 0 represents descending order, 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;
5. Press the shortcut keyalt+f+fYou can perform operations in ascending or descending order of ranking.
The above is all the content of excel using rank ranking formula and excel using formula to calculate ranking brought to you today, I hope it can help you.
How to rank excel from small to large excel how to sort by grade in descending order.
Sorting formula excel how to set ranking how to rank scrambled transcript.
How to operate the excel**summation formulaThe use of the excel**summation formula.
Excel multiplication formula tutorial example.
excel automatically find percentage formula excel how to enter percentage formula.