How to get the number of unique values 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