UNIQUE function on Google Sheets & Excel
The UNIQUE function in Google Sheets is used to extract unique values from a range or an array. Here's how you can use the UNIQUE function:
Open your Google Sheet and select the cell where you want to display the unique values.
Type =UNIQUE( and then select the range of cells or the array that contains the values you want to extract the unique values from.
For example, if you want to extract unique values from cells A1 to A10, you would type =UNIQUE(A1:A10).
Close the parentheses and press Enter.
The UNIQUE function will extract the unique values from the selected range or array and display them in the cell you selected.
Note: The UNIQUE function will only extract unique values from the range or array. If there are duplicate values, only one of them will be included in the output.