How to Use the RANGK.EQ Function in WPS on Windows

Use RANGK.EQ in 4 topics, all available in WPS Spreadsheet without membership, and follow the How-to Index to complete each task.

How-to Index

How-to Guide

1. Enter the RANGK.EQ function

Entry point: Select the target cell → formula bar

1. Open WPS Spreadsheet and go to the worksheet where you want to calculate rankings.
2. Select the cell where the ranking result should appear.
3. Type =RANGK.EQ(.
4. Enter the value cell and comparison range, for example =RANGK.EQ(A2,$A$2:$A$10).
5. Type the closing parenthesis and press Enter.

Success Criteria

• Interface result: The target cell shows a ranking result.
• Next action: You can continue editing the formula or fill it down to other rows.

Tips While Using

• Common mistake: Missing the equal sign, parentheses, or range reference can prevent the formula from calculating correctly.
• Environment note: The comparison range should contain values that can participate in calculation.

2. Set the ranking order

Entry point: Select the result cell → formula bar

1. Select the cell that already contains the RANGK.EQ formula.
2. Add the third argument after the second argument in the formula.
3. Enter 0, or leave the third argument omitted, for descending rank order.
4. Enter 1 for ascending rank order.
5. Press Enter and review the updated result.

Success Criteria

• Interface result: The ranking result updates when the order changes.
• Next action: You can switch between high-to-low and low-to-high ranking as needed.

Tips While Using

• Common mistake: Putting the order argument in the wrong position may break the formula structure.
• Environment note: Use the same order setting in one ranking column for easier comparison.

3. Fill ranking results down

Entry point: Use the fill handle at the lower-right corner of the first result cell

1. Enter the first RANGK.EQ formula in the top result cell.
2. Make sure the comparison range uses an absolute reference such as $A$2:$A$10.
3. Move the pointer to the lower-right corner of the result cell.
4. Drag the fill handle downward to copy the formula to other rows.
5. Check whether each row returns the expected rank.

Success Criteria

• Interface result: Multiple rows display ranking results continuously.
• Next action: You can continue sorting, filtering, or combining the results with other functions.

Tips While Using

• Common mistake: If the comparison range is not locked, the range may shift after filling down.
• Environment note: Confirm the first formula result is correct before filling the rest of the column.

4. Check and refresh calculation results

Entry point: Modify source data and review the result cells

1. Change one or more values that participate in the ranking.
2. Check whether the RANGK.EQ result cells update automatically.
3. If needed, select a result cell and review the formula in the formula bar.
4. Confirm that the referenced range still covers the full data set.
5. Save the workbook to keep the latest ranking results.

Success Criteria

• Interface result: Ranking results update after source data changes.
• Next action: You can continue expanding the report or exporting the file.

Tips While Using

• Common mistake: After adding new data, the comparison range may no longer cover the full list.
• Environment note: When using cross-sheet references, confirm the referenced range is still valid.