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

This how-to guide includes 3 operation topics for using RANGK.EQ in WPS Spreadsheet on Windows, with 3 available without membership and 0 membership-related items.

How-to Index

How-to Guide

1. Insert the function from the Insert Function dialog

Entry: Formula tab → Insert Function, or the fx button in the formula bar.

1. Select the cell where you want to enter the formula.
2. Click the fx button in the formula bar, or click Insert Function on the Formula tab.
3. Search for RANGK.EQ in the Insert Function dialog box.
4. Select the function and click OK.
5. Enter the required parameters in the Function Arguments dialog box.
6. Click OK to finish inserting the function.

Success Criteria

• Interface result: The target cell now contains the RANGK.EQ function.
• What you can do next: You can continue editing parameters, press Enter to confirm, or copy the formula to other cells.

Tips While Using

• It is helpful to search by the English function name.
• Before entering parameters, confirm that the ranking range and target value reference are correct.

2. Type the formula directly in a cell

Entry: The target cell or the formula bar.

1. Select the cell where you want to enter the formula.
2. Type =RANGK.EQ(...) directly in the cell or in the formula bar.
3. Press Enter to confirm.
4. If needed, continue entering parameters after the opening parenthesis to review formula hints.

Success Criteria

• Interface result: The cell returns a ranking result, and the full formula appears in the formula bar.
• What you can do next: You can fill down, copy and paste, or continue adjusting references.

Tips While Using

• Use English punctuation for parameter separators.
• When copying formulas in bulk, check whether relative and absolute references are set as intended.

3. Review function syntax and parameter details

Entry: Formula tab → Insert Function.

1. Click Insert Function on the Formula tab.
2. Enter RANGK.EQ in the search box.
3. Select the function to review its syntax and parameter details.
4. Click the related help link to open more detailed guidance.

Success Criteria

• Interface result: The function description area is open and shows syntax and parameter usage.
• What you can do next: You can return to the spreadsheet to enter the formula or adjust parameters based on the guidance.

Tips While Using

• If the result does not match expectations, check the parameter order and reference range first.
• When learning a new function, review the parameter meanings before formal entry.