Table of Contents
The UNIQUE function in Google Sheets allows users to filter out duplicate values within a specified range of cells. This function helps to streamline data and eliminate any unnecessary redundancies. By simply inputting the range of cells that need to be filtered, the UNIQUE function will automatically remove any duplicate values, leaving behind only unique entries. This can be particularly useful for organizing large datasets and ensuring accurate and efficient data analysis. With the UNIQUE function, users can easily clean up their data and focus on the unique information that is most relevant to their needs.
UNIQUE function
Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range.
Parts of a UNIQUE function
UNIQUE(range, by_column, exactly_once)
| Part | Description |
|---|---|
range | The data to filter by unique entries. |
by_column | Whether to filter the data by columns or by rows. By default, this is false. |
exactly_once | Whether to return only entries with no duplicates. By default, this is false. |
Notes
- If rows are returned which appear to be duplicates, ensure that cells including text do not have differing hidden text such as trailing spaces.
- Ensure that numeric values are formatted in the same way – percentages as percentages, currency values as currency values, etc.
Examples
| Color 1 | Color 2 | Color 3 | |
|---|---|---|---|
| Red | Yellow | Red | |
| Blue | Magenta | Blue | |
| Red | Yellow | Red | |
| Green | White | Green | |
| Formula | =UNIQUE(B2:D5) | ||
| Output | Red | Yellow | Red |
| Blue | Magenta | Blue | |
| Green | White | Green | |
| Formula | =UNIQUE(B2:D5, TRUE) | ||
| Output | Red | Yellow | |
| Blue | Magenta | ||
| Red | Yellow | ||
| Green | White | ||
| Formula | =UNIQUE(B2:D5, TRUE) | ||
| Output | Blue | Magenta | Blue |
| Green | White | Green | |
Related functions
- GT
- GTE
- LT
- LTE
Cite this article
stats writer (2024). How can I use the UNIQUE function in Google Sheets to filter out duplicate values in a range of cells?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-unique-function-in-google-sheets-to-filter-out-duplicate-values-in-a-range-of-cells/
stats writer. "How can I use the UNIQUE function in Google Sheets to filter out duplicate values in a range of cells?." PSYCHOLOGICAL SCALES, 29 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-unique-function-in-google-sheets-to-filter-out-duplicate-values-in-a-range-of-cells/.
stats writer. "How can I use the UNIQUE function in Google Sheets to filter out duplicate values in a range of cells?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-unique-function-in-google-sheets-to-filter-out-duplicate-values-in-a-range-of-cells/.
stats writer (2024) 'How can I use the UNIQUE function in Google Sheets to filter out duplicate values in a range of cells?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-unique-function-in-google-sheets-to-filter-out-duplicate-values-in-a-range-of-cells/.
[1] stats writer, "How can I use the UNIQUE function in Google Sheets to filter out duplicate values in a range of cells?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use the UNIQUE function in Google Sheets to filter out duplicate values in a range of cells?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.