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.
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?
