Method 1: Use the UNIQUE function
Scenario: Remove duplicates of customer information from the Customer List table.
Formula: UNIQUE([Customer List Table].[Company])
- Function: UNIQUE function
- Arguments: Customer List table, and the Company field.
Note: The green font in the formulas represents the table or field in the table.
Explanation: The UNIQUE function returns only unique values from the Company field. If you need to split the values returned into different fields, you can use the Text Split into Columns extension.
250px|700px|reset
250px|700px|reset
Method 2: Use IF and COUNTIF functions
Scenario: Check whether there are any duplicate product entries and mark them accordingly for inventory management.
Formula: IF(AND(Sales Table.COUNTIF(CurrentValue.field=Inventory Name)>1,Inventory Name).COUNTIF(CurrentValue!="")),"Duplicate",""）
- Functions: IF function, COUNTIF function, and AND function
- Arguments: Sales Table and Inventory Name field
Note: The green font in the formula represents the table or fields in the table.
Explanation: The COUNTIF function finds the product names that appear more than once in the Inventory Name field. The AND function assesses whether the data in the Inventory Name field is not blank. Finally, the IF function returns "Duplicate" for duplicate entries, otherwise it returns blank.
250px|700px|reset
250px|700px|reset
Method 3: Use the Delete Duplicate Records extension
This extension allows you to select one or more fields in which to look for and delete duplicates.
- Click the Base Extensions icon in ther upper-right corner of the base, select Delete Duplicate Records, and click Use.
- Configure the settings according to your needs and click Find Duplicate Records.
250px|700px|reset