The UNIQUE function in Google Sheets is a powerful tool that allows users to filter out duplicate entries from a specified range. By extracting only the unique rows, this function is particularly useful for data analysis and reporting, enabling users to condense their datasets for clearer insights and summaries.

Syntax

UNIQUE(range)

• range: This is the set of data from which unique rows will be extracted. It can encompass multiple rows and columns.

Example #1

=UNIQUE(A1:A5)

This function retrieves unique entries from the range A1 to A5. For instance, if the values are {Apple, Banana, Apple, Orange}, the result would be {Apple, Banana, Orange}.

Example #2

=UNIQUE(B1:C3)

Here, the function returns unique rows from the range B1 to C3. With sample data like {{1, 2}, {1, 3}, {2, 2}}, the output would be {{1, 2}, {1, 3}, {2, 2}}.

Example #3

=UNIQUE(D1:D10)

In this case, the function extracts unique values from D1 to D10. For a dataset that includes repeated items such as {Red, Blue, Blue, Green}, the result will be {Red, Blue, Green}.

Error handling

• N/A: This error appears when the specified range does not contain any data or when the range provided is invalid.
• REF: Occurs when the function references a range that is no longer valid, such as if cells have been deleted.
• VALUE: This error arises if the function receives incorrect type inputs, such as a text string instead of a range.

Conclusion

The UNIQUE function is an essential part of data management in Google Sheets. By providing a straightforward method to filter out duplicates, it enhances data analysis capabilities, thereby allowing users to focus on unique entries in their datasets. Integrating this function into your workflows can significantly streamline data processing and enhance the accuracy of your reports.