UNIQUE

Formulas / UNIQUE
The UNIQUE function returns a list of unique values from a list or range, ensuring that all names are different. It is an effective way to separate and manage data.
=UNIQUE(array,[by_col],[exactly_once])
  • array - required, the range or array to return a unique set of rows or columns from
  • by_col - [OPTIONAL] indicates how to compare cells
  • exactly_once - [OPTIONAL] returns rows or columns that occur exactly once in the range or array

Examples

  • =UNIQUE(A1:A10)

    This example returns the unique values in the range A1:A10. This example is useful when you need to find only the distinct values in a range of cells. For example, if you have a range of cells containing grades, you can use this function to return only the unique grades.

  • =UNIQUE(A1:E1,1)

    This example returns the range A1:E1 if the by_col argument is set to TRUE or 1. This example is useful when you need to return the unique values in a range of cells that span multiple columns. For example, if you have a range of cells spanning five columns that contain the names of students, you can use this function to return only the distinct student names.

Summary

The UNIQUE function returns a list of unique values from a list or range, ensuring that all names are different. It is an effective way to separate and manage data.

  • The UNIQUE function is case-insensitive, meaning "APPLE", "Apple", and "apple" are treated the same.
  • The UNIQUE and FILTER functions can be used together to filter out duplicate values.


Frequently Asked Questions

What is the UNIQUE function?
The UNIQUE function is used to return a list of unique values from either one or multiple columns.
Where can I use the UNIQUE function?
The UNIQUE function is available in Office 365 and is currently in beta on the Insiders channel.
What does the UNIQUE function do?
The UNIQUE function returns a list of values that occur once in either one or multiple columns.
Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV