Tips on how to Count Unique Ideals in Google Bed linens

Sometimes when working in Google Bedsheets you may desire to count typically the number of unique occurrences of data within your dataset.

This is the common task of which many spreadsheet consumers need to understand how to carry out. Luckily, within Google Sheets there are generally a number of ways to easily do this inside of your spreadsheet.

With this tutorial, I will certainly show you how to count unique beliefs in Google Sheets.

Table of Items [hide]

1 How to Employ COUNTUNIQUE

2 Exactly how to Use COUNTIF with UNIQUE

three or more Closing Thoughts





Precisely how to Use COUNTUNIQUE

The easiest method to count the initial values within your own dataset is along with the COUNTUNIQUE functionality.

This function number the number involving unique values within your selected variety.

The syntax involving this function is usually:

=COUNTUNIQUE(value1, [value2,? ])

value1? this is the range of files that you desire to count distinctive values regarding

value2? you can in addition add additional ideals or ranges in order to your data, this kind of is an optionally available unbekannte

Here is usually how to employ this formula:

In an empty cellular type first the formula =COUNTUNIQUE and press Tab about your keyboard to the formula

Go with your range of data that you want to count number unique values with regard to. In this example of this, There are selected most of column A

Add and shutting parenthesis? )? in addition to press Enter on your keyboard



COUNTUNIQUE

You can discover in the instance above I picked the entire line A in my range, plus the perform returned a value associated with 65. Therefore I have 65 distinctive values within that will selected range.

You can also use the COUNTUNIQUE function on numerous ranges, strings plus text values throughout addition to amounts.

Here are a few examples of other ways that this particular formula can be utilized:



countunique-2

How to Employ COUNTIF with UNIQUE

In order to count the particular unique occurrences of data and depend how many times each one of the data looks in the dataset, applying COUNTIF with typically the UNIQUE function is definitely a good option.

In the earlier example, many of us used COUNTUNIQUE, yet this only comes back the number of unique values in the selected range.

If we use COUNTIF with UNIQUE many of us can return the unique values and even count the quantity of times each value appears inside the selected variety.

To do this kind of we really need to combine three features: COUNTIF, ARRAYFORMULA, and even UNIQUE

COUNTIF? returns a count with the number of periods data appears inside a range.

ARRAYFORMULA? allows https://splice.com/lighttown7 to show off around multiple columns in addition to rows

UNIQUE? results the unique beliefs and gets purge of replicates



By combining these 3 formulas together, all of us get rid involving duplicates to returning unique values (UNIQUE), count the initial principles (COUNTIF), and go back the data across multiple rows plus columns (ARRAYFORMULA)

Here is the syntax of precisely how we are using that. We will end up being utilizing it on typically the same data as our last instance where we include 100 rows of data in column A:

UNIQUE(A2:A101),ARRAYFORMULA(COUNTIF(A2:A101,UNIQUE(A2:A101)))

Right here is how the particular formula will go back data when within use:

COUNT&UNIQUE

An individual can see the formula returns the particular unique values in one column, then the count from the numbers of times each unique worth appears within the particular data range throughout the next line.

Closing Thoughts

Inside of this tutorial, many of us have shown two different methods for counting the exclusive values within your schedule.



If group in google sheets would like to count the range of unique beliefs, COUNTUNIQUE is significantly faster, but if an individual would like to also count number the number of times every single value appears, COUNTIF + UNIQUE is definitely the method you need.