WPS table skills: quick ranking without changing the list order WPS table quick ranking without changing the list order

WPS tables often need to rank data, but ordinary ranking operations will change the original list order. How to quickly rank without changing the order of the original list? PHP editor Zimo has introduced in detail the techniques for quickly ranking WPS tables without changing the order of the list. Please read the following to learn more.

1. Select the cell and select Formula > Insert Function.

2. Enter rank in the search function, select the rank function, and click OK.

3. Enter the numerical value into the cell of the score.

4. In the reference box, the values ​​to be quoted here are C6~C19, use the [$] symbol for absolute reference. The ranking method [0] represents descending order, and if it is non-zero, it represents ascending order. Click OK.

5. Double-click the lower right corner to quickly fill. Just rank in order of student number

The above is the detailed content of WPS table skills: quick ranking without changing the list order WPS table quick ranking without changing the list order. For more information, please follow other related articles on the PHP Chinese website!