=UNIQUE(array,[by_col],[exactly_once])
=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.
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.