I. Intro
The UNIQUE function filters out duplicate values from a set of values. For example, you can use UNIQUE function with COUNTA function to calculate the number of unique visitors. You can also use LISTCOMBINE function with UNIQUE function to merge two data sets without any duplicates.
Arguments:
UNIQUE(value1, [value2, ...])
- Value 1: The first set of data that needs to be deduplicated. This can be a field in a base.
- Value 2: Other arrays or fields need to be deduplicated.
II. Steps
- Open the base and click the + icon on the rightmost side of the title. Enter the field title and change the field type to Formula.
250px|700px|reset
- Enter the UNIQUE function in the formula editor, and select the table or field to which you want to apply the formula.
For example, if you have duplicate entries in a product list and now need a list without any duplicates, you can use the UNIQUE function. As shown in the figure below, only unique products are returned.
250px|700px|reset
250px|700px|reset
III. Use cases
Scenario: For sales management, you may need to calculate the number of unique clients that are added to the database.
Formula: UNIQUE([Sales].FILTER(CurrentValue.[Date of submission]=[Date]).[Customer name]).COUNTA()
Description: The FILTER function filters for the names of companies in the "Sales" table. The UNIQUE function removes the duplicate companies, and COUNTA counts the number of entries.
250px|700px|reset
250px|700px|reset
IV. FAQs