UNIQUE

The UNIQUE function in Google Sheets is used to return unique rows from a given range, eliminating any duplicates. This function is particularly useful when you need to filter out redundant data. Discover more about its syntax and usage in our comprehensive guide below.

Function Syntax and Parameters

Syntax: UNIQUE(range, by_column, exactly_once)

Parameters:

• range: The range of cells from which to extract the unique rows.
• by_column: [Optional] A boolean value that determines whether to extract unique columns (default is false).
• exactly_once: [Optional] A boolean value that specifies whether to include only unique rows that appear once in the source range (default is false).

Step-by-Step Tutorial

1. Using UNIQUE function to extract unique rows:

   • Example: =UNIQUE(A1:B5)
   • Result: Returns the unique rows from the range A1:B5.

2. Extracting unique columns with UNIQUE function:

   • Example: =UNIQUE(A1:B5, true)
   • Result: Returns the unique columns instead of rows from the range A1:B5.

3. Including only unique rows that appear once:

   • Example: =UNIQUE(A1:B5, false, true)
   • Result: Returns only the unique rows that appear once in the range A1:B5.

Related Functions

• SORT: Sorts the rows of a specified range.
• FILTER: Filters a range of data based on specified criteria.

Related Articles

• Mastering Data Cleaning in Google Sheets: Removing Duplicates and Redundant Data
• Advanced Data Analysis Techniques in Google Sheets: Sorting and Filtering