UNIQUE
Formulas / UNIQUEThe 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.
Need help with Formulas?
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?
Where can I use the UNIQUE function?
What does the UNIQUE function do?
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.