How to get the number of unique values in a dataset

TL;DR — Need a way to figure out how many unique values you have in a dataset?

Need a way to figure out how many unique values you have in a dataset?


Use =COUNTUNIQUE(A:A) to get the count of unique values.

Easy!

formulas-countif

Common Use Cases


  • Getting a unique count of email addresses
  • Getting a unique count of account numbers

Tags

You might also like...

featured image thumbnail for post Timezone-safe dates in Sheets and Apps Script

Timezone-safe dates in Sheets and Apps Script

September 10, 2026

new Date() in Apps Script, a date cell in Sheets, and a teammate in another city will happily disagree by a day — and you'll spend an…

featured image thumbnail for post Script Properties for bootstrapper config

Script Properties for bootstrapper config

September 10, 2026

Hardcoding an API key in the script editor feels fine… until you share the project, clone it for another client, or paste the same file into…

featured image thumbnail for post Batch writes without timeouts

Batch writes without timeouts

September 10, 2026

When a script dies halfway through writing thousands of rows, you don't need a fancier API — you need a boring pattern: lock, chunk…