Last Updated on November 1, 2023 by Jake Sheridan
In this tutorial, you will learn how to filter unique values in Google Sheets.
How To Filter Unique Values in Google Sheets
When working with data in Google Sheets, you may want to find and filter unique values only. This can be helpful if you want to get a list of all the unique values in your data, for example.
Google Sheets does not have a built-in function to do this, but we can create a custom formula to filter unique values. The filter tool allows us to specify a custom formula as a condition for filtering values in a range.
In this guide, we will show you how to use the COUNTIF function to filter unique values in Google Sheets.
How to Filter A Column to Show Only Unique Values in Google Sheets
Here’s how to filter a column to show only unique values in Google Sheets.
First, select the range of values you want to filter for unique values.
Next, we’ll have to add a filter to the currently-selected range.
Click on the Create a filter option in the Data menu.
The header of the range should now have a Filter icon that you can click on to display various filter options.
Click on the ‘Filter by condition’ label to add a custom formula to filter for unique values.
Select the ‘Custom formula is’ option from the provided dropdown list.
We’ll use the formula =COUNTIF(A2:A,A2:A)=1 to find values that only appear once in the range.
The custom formula should now filter the range such that only unique values appear.
This guide should be everything you need to filter unique values in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.
More ways to filter in Google Sheets:
- Create Multiple Filters
- Create A Filter
- Create A Filter View
- How To Filter
- How To Create & Use Filter Views
- Filter By Multiple Conditions
- Filter By Color
- Filter Not Working (How To Fix)
- Filter by Date Range
- Filter Duplicates
- Filter Google Sheets Only For Me
- Extend Filter Range
- Filter Charts Using Slicer