How to Count Unique Values in Google Sheets

To count unique values in Google Sheets, you can use the UNIQUE function along with the COUNTA function. The UNIQUE function returns the unique values in a range, and the COUNTA function counts the number of non-empty cells in a range.

Here's how you can count unique values in Google Sheets:

1. Open your Google Sheet.
2. Click on an empty cell where you want to display the count of unique values.
3. Type the formula =COUNTA(UNIQUE(range)), where range is the range of cells you want to count unique values from.
4. Press Enter.

The cell will now display the count of unique values in the specified range.

Example

Let's say we have the following data in column A:

A
---
Item 1
Item 2
Item 1
Item 3
Item 2
Item 4
Item 5
Item 3

To count the unique values in this data, follow these steps:

1. Click on an empty cell, for example, B1.
2. Type the formula =COUNTA(UNIQUE(A1:A8)), where A1:A8 is the range containing the data.
3. Press Enter.

The cell B1 will now display the count of unique values in the range A1:A8, which is 5.