What is the COUNTUNIQUE formula in Google Sheets?

Have you ever found yourself working with a large data set within Google Sheets and needing to know how many times a unique value appears. This could be counting the number of times a product name, customer name or other unique value appears in your dataset. 

‍

You may also want to identify these unique values as a way to count duplicates and more easily eliminate these errors from your data. 

‍

Lee Stanton authored an article on alphr.com providing a step by step guide on how to use the COUNTUNIQUE formula. 

‍

Lee describes what you can learn from his article: 

‍

In this article, we’ll discuss how to count unique values in Google Sheets using the COUNTUNIQUE formula. We’ll also talk about counting unique values in a single column.

‍