{"id":651,"date":"2024-05-31T22:03:06","date_gmt":"2024-05-31T13:03:06","guid":{"rendered":"https:\/\/exceljump.com\/?p=651"},"modified":"2024-06-17T19:22:14","modified_gmt":"2024-06-17T10:22:14","slug":"duplicate-as-1","status":"publish","type":"post","link":"https:\/\/exceljump.com\/duplicate-as-1\/","title":{"rendered":"Pivot table : count unique values, duplicate values as 1","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"\n<p class=\"has-medium-font-size\">To count duplicate values as 1 in a pivot table of excel, follow these steps:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"1024\" src=\"https:\/\/exceljump.com\/wp-content\/uploads\/2024\/06\/pivot-table-count-unique-value-1024x1024.png\" alt=\"duplicate values as 1\" class=\"wp-image-657\" style=\"width:777px\" srcset=\"https:\/\/exceljump.com\/wp-content\/uploads\/2024\/06\/pivot-table-count-unique-value-1024x1024.png 1024w, https:\/\/exceljump.com\/wp-content\/uploads\/2024\/06\/pivot-table-count-unique-value-300x300.png 300w, https:\/\/exceljump.com\/wp-content\/uploads\/2024\/06\/pivot-table-count-unique-value-150x150.png 150w, https:\/\/exceljump.com\/wp-content\/uploads\/2024\/06\/pivot-table-count-unique-value-768x768.png 768w, https:\/\/exceljump.com\/wp-content\/uploads\/2024\/06\/pivot-table-count-unique-value.png 1080w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<ol>\n<li class=\"has-medium-font-size\"><strong>Select the data you want to use for the pivot table<\/strong><\/li>\n\n\n\n<li class=\"has-medium-font-size\"><strong>In the pivot table box, check the &#8220;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-data-model-in-excel-87e7a54c-87dc-488e-9410-5c75dbcb0f7b\">Add this data to the Data Model<\/a>&#8221; box and click OK<\/strong><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"788\" height=\"436\" src=\"https:\/\/exceljump.com\/wp-content\/uploads\/2024\/05\/duplicate-value.png\" alt=\"count duplicate values as 1\" class=\"wp-image-652\" srcset=\"https:\/\/exceljump.com\/wp-content\/uploads\/2024\/05\/duplicate-value.png 788w, https:\/\/exceljump.com\/wp-content\/uploads\/2024\/05\/duplicate-value-300x166.png 300w, https:\/\/exceljump.com\/wp-content\/uploads\/2024\/05\/duplicate-value-768x425.png 768w\" sizes=\"(max-width: 788px) 100vw, 788px\" \/><\/figure>\n\n\n\n<p class=\"has-medium-font-size\"><br><br><strong>3. Place the field you want to count<\/strong><\/p>\n\n\n\n<p class=\"has-medium-font-size\"><strong>4. In the values area (more options), select &#8220;Distinct Count&#8221; and click OK.<\/strong><\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>To count duplicate values as 1 in a pivot table of excel, follow these steps: 3. Place the field you want to count 4. In the values area (more options), &#8230;<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":657,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[2],"tags":[526,527,523,524,336,525],"jetpack_publicize_connections":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Pivot table : count unique values, duplicate values as 1<\/title>\n<meta name=\"description\" content=\"To count duplicate values as 1 in a pivot table of excel, follow these steps:\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceljump.com\/duplicate-as-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pivot table : count unique values, duplicate values as 1\" \/>\n<meta property=\"og:description\" content=\"To count duplicate values as 1 in a pivot table of excel, follow these steps:\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceljump.com\/duplicate-as-1\/\" \/>\n<meta property=\"og:site_name\" content=\"EXCEL JUMPER\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-31T13:03:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-17T10:22:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceljump.com\/wp-content\/uploads\/2024\/06\/pivot-table-count-unique-value.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1080\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Keckec\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Keckec\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceljump.com\/duplicate-as-1\/\",\"url\":\"https:\/\/exceljump.com\/duplicate-as-1\/\",\"name\":\"Pivot table : count unique values, duplicate values as 1\",\"isPartOf\":{\"@id\":\"https:\/\/exceljump.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceljump.com\/duplicate-as-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceljump.com\/duplicate-as-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceljump.com\/wp-content\/uploads\/2024\/06\/pivot-table-count-unique-value.png\",\"datePublished\":\"2024-05-31T13:03:06+00:00\",\"dateModified\":\"2024-06-17T10:22:14+00:00\",\"author\":{\"@id\":\"https:\/\/exceljump.com\/#\/schema\/person\/5202d52cc0afb625464149c4d38f6d5d\"},\"description\":\"To count duplicate values as 1 in a pivot table of excel, follow these steps:\",\"breadcrumb\":{\"@id\":\"https:\/\/exceljump.com\/duplicate-as-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceljump.com\/duplicate-as-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/exceljump.com\/duplicate-as-1\/#primaryimage\",\"url\":\"https:\/\/exceljump.com\/wp-content\/uploads\/2024\/06\/pivot-table-count-unique-value.png\",\"contentUrl\":\"https:\/\/exceljump.com\/wp-content\/uploads\/2024\/06\/pivot-table-count-unique-value.png\",\"width\":1080,\"height\":1080,\"caption\":\"pivot table duplicate value counting\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceljump.com\/duplicate-as-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/exceljump.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pivot table : count unique values, duplicate values as 1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceljump.com\/#website\",\"url\":\"https:\/\/exceljump.com\/\",\"name\":\"EXCEL JUMPER\",\"description\":\"excel formulas, excel functions, excel shortcut keys\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceljump.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/exceljump.com\/#\/schema\/person\/5202d52cc0afb625464149c4d38f6d5d\",\"name\":\"Keckec\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/exceljump.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ae82d9527bb79ad9c206f44fc3069b7a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ae82d9527bb79ad9c206f44fc3069b7a?s=96&d=mm&r=g\",\"caption\":\"Keckec\"},\"sameAs\":[\"https:\/\/exceljump.com\"],\"url\":\"https:\/\/exceljump.com\/author\/keckec\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Pivot table : count unique values, duplicate values as 1","description":"To count duplicate values as 1 in a pivot table of excel, follow these steps:","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceljump.com\/duplicate-as-1\/","og_locale":"en_US","og_type":"article","og_title":"Pivot table : count unique values, duplicate values as 1","og_description":"To count duplicate values as 1 in a pivot table of excel, follow these steps:","og_url":"https:\/\/exceljump.com\/duplicate-as-1\/","og_site_name":"EXCEL JUMPER","article_published_time":"2024-05-31T13:03:06+00:00","article_modified_time":"2024-06-17T10:22:14+00:00","og_image":[{"width":1080,"height":1080,"url":"https:\/\/exceljump.com\/wp-content\/uploads\/2024\/06\/pivot-table-count-unique-value.png","type":"image\/png"}],"author":"Keckec","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Keckec","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceljump.com\/duplicate-as-1\/","url":"https:\/\/exceljump.com\/duplicate-as-1\/","name":"Pivot table : count unique values, duplicate values as 1","isPartOf":{"@id":"https:\/\/exceljump.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceljump.com\/duplicate-as-1\/#primaryimage"},"image":{"@id":"https:\/\/exceljump.com\/duplicate-as-1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceljump.com\/wp-content\/uploads\/2024\/06\/pivot-table-count-unique-value.png","datePublished":"2024-05-31T13:03:06+00:00","dateModified":"2024-06-17T10:22:14+00:00","author":{"@id":"https:\/\/exceljump.com\/#\/schema\/person\/5202d52cc0afb625464149c4d38f6d5d"},"description":"To count duplicate values as 1 in a pivot table of excel, follow these steps:","breadcrumb":{"@id":"https:\/\/exceljump.com\/duplicate-as-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceljump.com\/duplicate-as-1\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/exceljump.com\/duplicate-as-1\/#primaryimage","url":"https:\/\/exceljump.com\/wp-content\/uploads\/2024\/06\/pivot-table-count-unique-value.png","contentUrl":"https:\/\/exceljump.com\/wp-content\/uploads\/2024\/06\/pivot-table-count-unique-value.png","width":1080,"height":1080,"caption":"pivot table duplicate value counting"},{"@type":"BreadcrumbList","@id":"https:\/\/exceljump.com\/duplicate-as-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/exceljump.com\/"},{"@type":"ListItem","position":2,"name":"Pivot table : count unique values, duplicate values as 1"}]},{"@type":"WebSite","@id":"https:\/\/exceljump.com\/#website","url":"https:\/\/exceljump.com\/","name":"EXCEL JUMPER","description":"excel formulas, excel functions, excel shortcut keys","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceljump.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/exceljump.com\/#\/schema\/person\/5202d52cc0afb625464149c4d38f6d5d","name":"Keckec","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/exceljump.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ae82d9527bb79ad9c206f44fc3069b7a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ae82d9527bb79ad9c206f44fc3069b7a?s=96&d=mm&r=g","caption":"Keckec"},"sameAs":["https:\/\/exceljump.com"],"url":"https:\/\/exceljump.com\/author\/keckec\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/exceljump.com\/wp-content\/uploads\/2024\/06\/pivot-table-count-unique-value.png","gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/exceljump.com\/wp-json\/wp\/v2\/posts\/651"}],"collection":[{"href":"https:\/\/exceljump.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exceljump.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exceljump.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceljump.com\/wp-json\/wp\/v2\/comments?post=651"}],"version-history":[{"count":3,"href":"https:\/\/exceljump.com\/wp-json\/wp\/v2\/posts\/651\/revisions"}],"predecessor-version":[{"id":659,"href":"https:\/\/exceljump.com\/wp-json\/wp\/v2\/posts\/651\/revisions\/659"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/exceljump.com\/wp-json\/wp\/v2\/media\/657"}],"wp:attachment":[{"href":"https:\/\/exceljump.com\/wp-json\/wp\/v2\/media?parent=651"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exceljump.com\/wp-json\/wp\/v2\/categories?post=651"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exceljump.com\/wp-json\/wp\/v2\/tags?post=651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}