SheetFX
≡
<< Go back to all functions

COUNTUNIQUE

The COUNTUNIQUE function in Google Sheets is a powerful tool to count the number of unique values in a list of specified values and ranges. Whether you're analyzing survey responses, tracking customer preferences, or identifying unique items in a dataset, the COUNTUNIQUE function simplifies the task. Dive into our comprehensive guide to master its application.

Function Syntax and Parameters

Syntax: COUNTUNIQUE(value1, [value2, ...])

Parameters:

  • value1: The first value or range to consider for counting unique values.
  • value2, ...: [Optional] Additional values or ranges to consider.

Step-by-Step Tutorial

  1. Using COUNTUNIQUE with individual values:

    • Example: =COUNTUNIQUE(1, 2, 3, 2, 4)
    • Result: 4

  2. Using COUNTUNIQUE with a range of cells:

    • Example: If A1:A5 has the values 1, 2, 3, 2, 4, then =COUNTUNIQUE(A1:A5) will return 4.

Use Cases and Scenarios

  1. Survey Analysis: Determine the number of unique responses to a survey question.
  2. Customer Segmentation: Count the number of unique customer groups based on specific characteristics.
  3. Data Deduplication: Identify the number of unique entries in a dataset and remove duplicates.

Related Functions

  • COUNT: Count the number of cells within a range that contain numbers.
  • COUNTA: Count the number of cells within a range that are not empty.

Related Articles