How to Use the FILTER Function in WPS on Windows

Last updated:July 23, 2026

This how-to guide includes 3 topics, all available without membership; choose a topic from the index and follow the entry path and steps to complete the setup.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and use FILTERFree
22. Review the parameter formatFree
33. Enter an example and check the resultFree

How-to Guide

1. Create a formula field and use FILTER

Entry path: Add Field → Formula → Formula Editor

  1. Click Add Field on the toolbar.
  2. Select Formula as the field type.
  3. Enter a formula that includes FILTER in the formula editor.
  4. Fill in the target range and condition values as needed.
  5. Click Confirm to save and review the calculated result.

Success Criteria

  • Interface result: A new formula field appears in the table and shows the calculated result.
  • Next action available: You can continue editing the formula parameters or adjust the referenced range.

Tips While Using

  • Common mistake: If you do not create a formula field first, you cannot enter the function formula in a regular field.
  • Environment note: You need edit permission for the current multidimensional table.

2. Review the parameter format

Entry path: Formula Editor → Function Library → FILTER

  1. Open the function library in the formula editor.
  2. Select FILTER to review its format.
  3. Build the formula with the structure FILTER([parameter1], [parameter2], ...).
  4. Put the target data range in the first parameter position.
  5. Put the filtering condition in the following parameter positions.

Success Criteria

  • Interface result: The formula structure is complete and the parameter positions are clear.
  • Next action available: You can continue adding conditions or adjusting references.

Tips While Using

  • Common mistake: If the parameter order is mixed up, the result may not return as expected.
  • Environment note: The condition field should correspond to the target range.

3. Enter an example and check the result

Entry path: Formula Field → Enter Example Formula → Save and Review Result

  1. Enter an example formula in the formula field.
  2. Replace the target range and conditions with values from the current table.
  3. Save the formula and return to the table to review the result.
  4. Check whether the result refreshes when the source data changes.

Success Criteria

  • Interface result: The formula field shows the filtered result.
  • Next action available: After changing source data, you can observe the result update accordingly.

Tips While Using

  • Common mistake: If the referenced range and condition field do not match, the formula may return an error.
  • Environment note: If the data is empty or the condition is not met, the result may be empty or return an error.