How to Use a Deduplication Formula in WPS on Windows

Last updated:July 23, 2026

Use this formula through 3 how-to topics: create a formula field and call the function, review the parameter structure, and build a common example formula.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and call the functionFree
22. Review the parameter structureFree
33. Build a common exampleFree

How-to Guide

1. Create a formula field and call the function

Entry: Add Field → Formula → Formula Editor

  1. Open the multidimensional table that contains the data you want to process.
  2. Click Add Field.
  3. Select Formula as the field type.
  4. In the formula editor, enter the formula name and the target range.
  5. Click Confirm to save the formula and review the returned result.

Success Criteria

  • A formula field has been added successfully.
  • The saved formula returns a deduplicated result.
  • The result can refresh when source data changes.

Tips While Using

  • Confirm that the referenced range points to the correct data.
  • If the result looks wrong, check the field type and function spelling first.

2. Review the parameter structure

Entry: Formula Editor → Function Library → Related formula

  1. Open the formula editor in your multidimensional table.
  2. Go to the function library and find the related formula entry.
  3. Review the function structure and parameter positions.
  4. Fill in the parameters based on your actual data range.
  5. Save the formula and check whether the returned result matches your expectation.

Success Criteria

  • The formula entry is available in the function library.
  • The parameter positions are filled in completely.
  • The formula saves and returns a result normally.

Tips While Using

  • Make sure the referenced range matches the current table data.
  • Keep parentheses, commas, and other symbols complete when typing the formula.

3. Build a common example

Entry: Formula Field → Edit Formula

  1. Create or select a formula field.
  2. Enter an example formula with a target range.
  3. If needed, continue combining it with other functions.
  4. Save the formula and review the result.
  5. Change the source data and confirm that the result refreshes automatically.

Success Criteria

  • The example formula runs normally.
  • The deduplicated result appears in the field.
  • A combined formula continues to calculate after data updates.

Tips While Using

  • When nesting other functions, check the formula structure step by step.
  • Test with a small data set first, then expand to the full table.