Syntax<\/h3>\n
COUNTUNIQUE(value1, [value2, \u2026])<\/strong><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n We have just learned the syntax to the formula. Now it is time to dive headfirst into\u00a0practically applying this newfound knowledge on the Google Sheets application. Take a look at the image below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/COUNTUNIQUE-formula-Illustration-Frame-1.png” alt=”COUNTUNIQUE Google Sheets: Usage” title_text=”countunique-formula-usage” _builder_version=”4.16″ width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The first example consumes direct numeric values and returns the count of unique instances of each value. The second example is a demonstration that shows us that the COUNTUNIQUE formula can use references to cells that store values. In the third example, instead of sending multiple values or references, we have passed a single composite range. This composite cell range consists of all the values from A2 through A11. And, in the final example, we not only passed direct numeric values but also a couple range references.<\/p>\n You\u2019ll observe that the output is the same across all examples, regardless of the approach that we have taken with the formula. If we quickly validate the input dataset, we will indeed notice that there are 7 unique values within column A. And that is what the formula has returned.<\/p>\n The COUNTUNIQUE formula is not just confined to numeric values. It can also consider strings for input values. We have demonstrated this capability in the following image.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/COUNTUNIQUE-formula-Illustration-Frame-2.png” alt=”COUNTUNIQUE Google Sheets: Strings Input Values” title_text=”countunique-strings-input-value” _builder_version=”4.16″ width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You can read more about the COUNT formula in the following blog: <\/span>How to use the COUNT formula in Google Sheets<\/a>.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" While working with spreadsheets, we are bound to do many sorts of calculations. And we will, at times need to calculate unique occurrences of a dataset. The number of unique customers that shopped at a store, for example. How do we achieve this easily? We can, with the help of\u00a0COUNTUNIQUE\u00a0formula in Google Sheets application. Syntax […]<\/p>\n","protected":false},"author":40,"featured_media":8845,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"While working with spreadsheets, we are bound to do many sorts of calculations. And we will, at times need to calculate unique occurrences of a dataset. The number of unique customers that shopped at a store, for example. How do we achieve this easily? We can, with the help of COUNTUNIQUE<\/a> formula in Google Sheets application.\n\n
Usage: COUNTUNIQUE formula in Google Sheets<\/h3>\n
Note<\/h4>\n
Syntax<\/h3>\nCOUNTUNIQUE(value1, [value2, ...])<\/strong>\n
\n \t
Usage: COUNTUNIQUE formula in Google Sheets<\/h3>\nWe have just learned the syntax to the formula. Now it is time to dive headfirst into\u00a0practically applying this newfound knowledge on the Google Sheets application. Take a look at the image below.\n\n
![\"COUNTUNIQUE](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/COUNTUNIQUE-formula-Illustration-Frame-1.png\")
\n\nThe first example consumes direct numeric values and returns the count of unique instances of each value. The second example is a demonstration that shows us that the COUNTUNIQUE formula can use references to cells that store values. In the third example, instead of sending multiple values or references, we have passed a single composite range. This composite cell range consists of all the values from A2 through A11. And, in the final example, we not only passed direct numeric values but also a couple range references.\n\nYou\u2019ll observe that the output is the same across all examples, regardless of the approach that we have taken with the formula. If we quickly validate the input dataset, we will indeed notice that there are 7 unique values within column A. And that is what the formula has returned.\nNote<\/h4>\nThe COUNTUNIQUE formula is not just confined to numeric values. It can also consider strings for input values. We have demonstrated this capability in the following image.\n\n
![\"COUNTUNIQUE](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/COUNTUNIQUE-formula-Illustration-Frame-2.png\")
","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-8844","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/8844","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=8844"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/8844\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/8845"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=8844"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=8844"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=8844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}