Google Sheets

UNIQUE: Google Sheets Formulae Explained

How do you use UNIQUE in Google Sheets?

The UNIQUE function in Google Sheets allows you to identify and remove duplicate entries from a list or range of cells. You can use it to compare two lists of data, or to remove duplicates from a list of data that you've already imported into Google Sheets. To use the UNIQUE function, select the list or range of cells that you want to analyze, and then enter the following formula:

=UNIQUE(list1, list2, [ignore_empty])

The function will return a list of unique entries, based on the criteria that you specify. You can use the optional "ignore_empty" argument to tell the function to ignore any cells that are empty or contain only whitespace.

What is the syntax of UNIQUE in Google Sheets?

The syntax of UNIQUE in Google Sheets is to use the function name followed by a set of parentheses, within which you list the column or range of columns you want to check for uniqueness. The function will return a TRUE or FALSE value depending on whether the data in each column is unique.

What is an example of how to use UNIQUE in Google Sheets?

One way to use UNIQUE is to create a list of unique items from a larger list. For example, you can use the function to create a list of unique colors from a list of all colors. To do this, you would type the following into a Google Sheet: =UNIQUE(A1:A20) This will create a list of unique colors from A1 to A20.

Another way to use UNIQUE is to create a list of unique values from a larger list. For example, you can use the function to create a list of unique numbers from a list of all numbers. To do this, you would type the following into a Google Sheet: =UNIQUE(B1:B20) This will create a list of unique numbers from B1 to B20.

When should you not use UNIQUE in Google Sheets?

There are a few occasions when you should not use UNIQUE in Google Sheets. First, if you have a list of numbers and you want to find the unique ones, you can use the function COUNTUNIQUE instead. Second, if you are trying to merge two lists of data and want to keep the unique values, you can use the function VLOOKUP instead. Finally, if you want to find the position of a unique value in a list, you can use the function INDEX instead.

What are some similar formulae to UNIQUE in Google Sheets?

There are a few similar formulae to UNIQUE in Google Sheets. The first is COUNTIF, which counts the number of times a specific value appears in a range of cells. The second is INDEX, which returns the value of a specific cell in a range of cells. The third is MATCH, which returns the position of a specific value in a range of cells. Finally, the fourth is VLOOKUP, which returns the value of a specific cell in a table of data.

Move beyond 

Google Sheets

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.