{"id":16997,"date":"2025-01-03T01:30:00","date_gmt":"2025-01-02T16:30:00","guid":{"rendered":"https:\/\/84office.jp\/?p=16997"},"modified":"2025-01-04T08:55:35","modified_gmt":"2025-01-03T23:55:35","slug":"duplicate-data-extraction","status":"publish","type":"post","link":"https:\/\/84office.jp\/en\/duplicate-data-extraction\/","title":{"rendered":"How to Identify Duplicate Data in Google Sheets: Using Functions and Conditional Formatting"},"content":{"rendered":"<div class=\"codoc-evacuations\" style=\"display:none;\" data-shortcode=\"\"><\/div>\n<p>In our previous article, we covered how to remove duplicate data in Google Sheets. This time, we\u2019ll focus on <strong>how to extract duplicate data<\/strong> efficiently.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40\">Using functions is ideal when you want to automate the extraction process, while conditional formatting is perfect for visually identifying duplicates at a glance. Both methods offer unique advantages depending on your specific needs.<\/p>\n\n\n<div class=\"swell-block-postLink u-mb-ctrl u-mb-60\">\t\t\t<div class=\"p-blogCard -internal\" data-type=\"type1\" data-onclick=\"clickLink\">\n\t\t\t\t<div class=\"p-blogCard__inner\">\n\t\t\t\t\t<span class=\"p-blogCard__caption\">\u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/span>\n\t\t\t\t\t<div class=\"p-blogCard__thumb c-postThumb\"><figure class=\"c-postThumb__figure\"><img decoding=\"async\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/f713dfc6aeb4da01bcd388842c732c69-300x158.png\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" width=\"320\" height=\"180\"><\/figure><\/div>\t\t\t\t\t<div class=\"p-blogCard__body\">\n\t\t\t\t\t\t<a class=\"p-blogCard__title\" href=\"https:\/\/84office.jp\/en\/duplicate-data-extraction\/\">How to Identify Duplicate Data in Google Sheets: Using Functions and Conditional Formatting<\/a>\n\t\t\t\t\t\t<span class=\"p-blogCard__excerpt\">In our previous article, we covered how to remove duplicate data in Google Sheets. This time, we\u2019ll focus on how to extract duplicate data efficiently. Using&#8230;<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n<h2 class=\"wp-block-heading u-mb-ctrl u-mb-30\"><strong>Extracting Duplicate Data Using Functions<\/strong><\/h2>\n\n\n\n<div class=\"swell-block-capbox cap_box is-style-onborder_ttl2 u-mb-ctrl u-mb-40\" data-colset=\"col3\"><div class=\"cap_box_ttl\"><span>Main Methods for Extracting Duplicate Data with Functions<\/span><\/div><div class=\"cap_box_content\">\n<ul class=\"wp-block-list is-style-num_circle\">\n<li><strong>To display all rows with duplicate data:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Use a combination of the <code>FILTER()<\/code> and <code>COUNTIF()<\/code> functions.<br><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>To display duplicate data only once:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Use a combination of the <code>UNIQUE()<\/code> and <code>FILTER()<\/code> functions.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40\">There are two main methods to extract duplicate data using functions.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u2460<\/strong><strong>Function to Display All Rows with Duplicate Data (FILTER and COUNTIF)<\/strong><\/h3>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"943\" height=\"593\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image.png\" alt=\"\" class=\"wp-image-16998\" style=\"width:514px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image.png 943w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-300x189.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-768x483.png 768w\" sizes=\"(max-width: 943px) 100vw, 943px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-0\">Example Formula:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro u-mb-ctrl u-mb-40\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"=FILTER(A2:A, COUNTIF(A2:A, A2:A) &gt; 1)\" style=\"color:#F8F8F2;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki monokai\" style=\"background-color: #272822\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F92672\">=<\/span><span style=\"color: #A6E22E\">FILTER<\/span><span style=\"color: #F8F8F2\">(A2:A, <\/span><span style=\"color: #A6E22E\">COUNTIF<\/span><span style=\"color: #F8F8F2\">(A2:A, A2:A) <\/span><span style=\"color: #F92672\">&gt;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #AE81FF\">1<\/span><span style=\"color: #F8F8F2\">)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<div class=\"wp-block-group has-border -border01 u-mb-ctrl u-mb-60\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p>All duplicate data in column A will be displayed.<\/p>\n\n\n\n<p>In this formula, the <code>COUNTIF<\/code> function is used to check how many times each cell&#8217;s value appears, and the <code>FILTER()<\/code> function extracts the data where the occurrence count is greater than 1.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-60\">This method is useful when you want to display all duplicate rows.<\/p>\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\u2461<strong><strong>Function to Display Duplicate Data Only Once (UNIQUE and FILTER)<\/strong><\/strong><\/h3>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"952\" height=\"591\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-1.png\" alt=\"\" class=\"wp-image-16999\" style=\"width:514px\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-1.png 952w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-1-300x186.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-1-768x477.png 768w\" sizes=\"(max-width: 952px) 100vw, 952px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-0\">Example Formula:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro u-mb-ctrl u-mb-40\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"=UNIQUE(FILTER(A2:A, COUNTIF(A2:A, A2:A) &gt; 1))\" style=\"color:#F8F8F2;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki monokai\" style=\"background-color: #272822\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F92672\">=<\/span><span style=\"color: #A6E22E\">UNIQUE<\/span><span style=\"color: #F8F8F2\">(<\/span><span style=\"color: #A6E22E\">FILTER<\/span><span style=\"color: #F8F8F2\">(A2:A, <\/span><span style=\"color: #A6E22E\">COUNTIF<\/span><span style=\"color: #F8F8F2\">(A2:A, A2:A) <\/span><span style=\"color: #F92672\">&gt;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #AE81FF\">1<\/span><span style=\"color: #F8F8F2\">))<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<div class=\"wp-block-group has-border -border01 u-mb-ctrl u-mb-60\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p>The duplicate data (e.g., &#8220;Laptop,&#8221; &#8220;Keyboard,&#8221; &#8220;Monitor&#8221;) will be displayed only once.<\/p>\n\n\n\n<p>The <code>FILTER()<\/code> function is used to extract the duplicate data, and the <code>UNIQUE()<\/code> function then lists each duplicate data entry only once.<\/p>\n\n\n\n<p>This method is useful when you want to identify the types of duplicate data.<\/p>\n<\/div><\/div>\n\n\n\n<p><strong>To Display the Number of Duplicates for Each Data<\/strong><\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large is-resized\"><img decoding=\"async\" width=\"1024\" height=\"508\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-2-1024x508.png\" alt=\"\" class=\"wp-image-17000\" style=\"width:580px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-2-1024x508.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-2-300x149.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-2-768x381.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-2.png 1158w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-0\">Example Formula to Show Duplicate Counts:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"=ARRAYFORMULA(IF(C2:C &lt;&gt; &quot;&quot;, COUNTIF(A:A, C2:C), &quot;&quot;))\" style=\"color:#F8F8F2;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki monokai\" style=\"background-color: #272822\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F92672\">=<\/span><span style=\"color: #A6E22E\">ARRAYFORMULA<\/span><span style=\"color: #F8F8F2\">(<\/span><span style=\"color: #A6E22E\">IF<\/span><span style=\"color: #F8F8F2\">(C2:C <\/span><span style=\"color: #F92672\">&lt;&gt;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">&quot;&quot;<\/span><span style=\"color: #F8F8F2\">, <\/span><span style=\"color: #A6E22E\">COUNTIF<\/span><span style=\"color: #F8F8F2\">(A:A, C2:C), <\/span><span style=\"color: #E6DB74\">&quot;&quot;<\/span><span style=\"color: #F8F8F2\">))<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<div class=\"wp-block-group has-border -border01 u-mb-ctrl u-mb-60\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p>The number of times each data item in column C appears in column A will be displayed in column D.<\/p>\n\n\n\n<p>This allows you to identify the types of duplicate data and their occurrence counts.<\/p>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Highlighting Duplicate Data Using Conditional Formatting<\/strong><\/h2>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-30\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"966\" height=\"621\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-4.png\" alt=\"\" class=\"wp-image-17002\" style=\"width:452px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-4.png 966w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-4-300x193.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-4-768x494.png 768w\" sizes=\"(max-width: 966px) 100vw, 966px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"has-border -border02 u-mb-ctrl u-mb-50 has-swl-pale-03-background-color has-background\"><strong>Conditional formatting is a convenient way to visually identify duplicate data.<\/strong><\/p>\n\n\n\n<div class=\"swell-block-step\" data-num-style=\"circle\">\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Select the Data Range<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"547\" height=\"609\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-6.png\" alt=\"\" class=\"wp-image-17006\" style=\"width:380px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-6.png 547w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-6-269x300.png 269w\" sizes=\"(max-width: 547px) 100vw, 547px\" \/><\/figure>\n<\/div>\n\n\n<p>Choose the range of data where you want to find duplicates.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Open Conditional Formatting<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large is-resized\"><img decoding=\"async\" width=\"662\" height=\"1024\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/cd084cfc6f42240f787fc91832d32143-662x1024.png\" alt=\"\" class=\"wp-image-17004\" style=\"width:377px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/cd084cfc6f42240f787fc91832d32143-662x1024.png 662w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/cd084cfc6f42240f787fc91832d32143-194x300.png 194w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/cd084cfc6f42240f787fc91832d32143.png 709w\" sizes=\"(max-width: 662px) 100vw, 662px\" \/><\/figure>\n<\/div>\n\n\n<p>From the menu, select <strong>&#8220;Format&#8221;<\/strong> \u2192 <strong>&#8220;Conditional formatting.&#8221;<\/strong><\/p>\n\n\n\n<p>(You can also right-click and select <strong>&#8220;Conditional formatting&#8221;<\/strong> from the context menu.)<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Choose Custom Formula<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"668\" height=\"812\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/a0a19f75999c82fad8f80d3726ef7d99.png\" alt=\"\" class=\"wp-image-17007\" style=\"width:357px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/a0a19f75999c82fad8f80d3726ef7d99.png 668w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/a0a19f75999c82fad8f80d3726ef7d99-247x300.png 247w\" sizes=\"(max-width: 668px) 100vw, 668px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-40\">In the conditional formatting rules, select <strong>&#8220;Custom formula is&#8221;<\/strong> and enter the following formula.<\/p>\n\n\n\n<p>Example Formula (to check column A):<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"=COUNTIF(A:A, A1) &gt; 1\" style=\"color:#F8F8F2;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki monokai\" style=\"background-color: #272822\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F92672\">=<\/span><span style=\"color: #A6E22E\">COUNTIF<\/span><span style=\"color: #F8F8F2\">(A:A, A1) <\/span><span style=\"color: #F92672\">&gt;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #AE81FF\">1<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n\n\n\n\n\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Select the Desired Color and Finish<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"646\" height=\"379\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-7.png\" alt=\"\" class=\"wp-image-17008\" style=\"width:301px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-7.png 646w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-7-300x176.png 300w\" sizes=\"(max-width: 646px) 100vw, 646px\" \/><\/figure>\n<\/div>\n\n\n<p>Choose your preferred color for highlighting and click <strong>&#8220;Done&#8221;<\/strong> to apply the formatting.<\/p>\n<\/div><\/div>\n<\/div>\n\n\n\n\n\n\n\n<h2 class=\"wp-block-heading u-mb-ctrl u-mb-30\">Conclusion<\/h2>\n\n\n\n<p>There are several methods to extract duplicate data in Google Sheets, including using functions and conditional formatting.<\/p>\n\n\n\n<p>For more advanced customization, you can also use Google Apps Script (GAS) to extract duplicate data.<\/p>\n\n\n\n<p>Choose the method that best fits your specific needs to streamline your workflow effectively.<\/p>\n\n\n\n<ul class=\"wp-block-list u-mb-ctrl u-mb-30 has-swl-pale-03-background-color has-background\">\n<li><strong>Functions:<\/strong> When you want to automatically filter duplicates.<\/li>\n\n\n\n<li><strong>Conditional Formatting:<\/strong> When you need to visually identify duplicates.<\/li>\n\n\n\n<li><strong>GAS (Google Apps Script):<\/strong> When customized processing is required.<\/li>\n<\/ul>\n\n\n<div class=\"swell-block-postLink u-mb-ctrl u-mb-30\">\t\t\t<div class=\"p-blogCard -internal\" data-type=\"type1\" data-onclick=\"clickLink\">\n\t\t\t\t<div class=\"p-blogCard__inner\">\n\t\t\t\t\t<span class=\"p-blogCard__caption\">\u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/span>\n\t\t\t\t\t<div class=\"p-blogCard__thumb c-postThumb\"><figure class=\"c-postThumb__figure\"><img decoding=\"async\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/f713dfc6aeb4da01bcd388842c732c69-300x158.png\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" width=\"320\" height=\"180\"><\/figure><\/div>\t\t\t\t\t<div class=\"p-blogCard__body\">\n\t\t\t\t\t\t<a class=\"p-blogCard__title\" href=\"https:\/\/84office.jp\/en\/duplicate-data-extraction\/\">How to Identify Duplicate Data in Google Sheets: Using Functions and Conditional Formatting<\/a>\n\t\t\t\t\t\t<span class=\"p-blogCard__excerpt\">In our previous article, we covered how to remove duplicate data in Google Sheets. This time, we\u2019ll focus on how to extract duplicate data efficiently. Using&#8230;<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n<div class=\"p-postListWrap u-mb-ctrl u-mb-30\"><ul class=\"p-postList -type-simple\"><li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/gmail-bulk-send-template\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__body\">\n\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2025-07-20\" aria-label=\"\u516c\u958b\u65e5\">2025\u5e747\u670820\u65e5<\/time><\/div>\n\t\t<span class=\"p-postList__cat u-thin icon-folder\" data-cat-id=\"12\">Google Sheets<\/span>\n\t\t\t\t<\/div>\n\t\t\t<h2 class=\"p-postList__title\">Gmail Bulk Sending Template | Easily Send to Multiple Recipients via Google Sheets<\/h2>\t\t<\/div>\n\t<\/a>\n<\/li>\n<li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/google-calendar-free-time-extraction\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__body\">\n\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2025-07-24\" aria-label=\"\u516c\u958b\u65e5\">2025\u5e747\u670824\u65e5<\/time><\/div>\n\t\t<span class=\"p-postList__cat u-thin icon-folder\" data-cat-id=\"12\">Google Sheets<\/span>\n\t\t\t\t<\/div>\n\t\t\t<h2 class=\"p-postList__title\">How to Find Common Free Time in Google Calendar: Manage Shared Schedules with Google Apps Script<\/h2>\t\t<\/div>\n\t<\/a>\n<\/li>\n<li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/cleanup-duplicate-data-removal\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__body\">\n\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2025-01-02\" aria-label=\"\u516c\u958b\u65e5\">2025\u5e741\u67082\u65e5<\/time><\/div>\n\t\t<span class=\"p-postList__cat u-thin icon-folder\" data-cat-id=\"12\">Google Sheets<\/span>\n\t\t\t\t<\/div>\n\t\t\t<h2 class=\"p-postList__title\">How to Easily Remove Duplicate Data in Google Sheets: No Functions Required<\/h2>\t\t<\/div>\n\t<\/a>\n<\/li>\n<\/ul><\/div>\n\n\n<div class=\"wp-block-group is-style-emboss_box has-swl-pale-02-background-color has-background\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p>\u5f0a\u793e\u3067\u306f\u3001Google Apps Script\uff08GAS\uff09\u3092\u6d3b\u7528\u3057\u305f\u696d\u52d9\u52b9\u7387\u5316\u306e\u30b5\u30dd\u30fc\u30c8\u3092\u63d0\u4f9b\u3057\u3066\u304a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>GAS\u306e\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u3084\u30a8\u30e9\u30fc\u5bfe\u5fdc\u306b\u304a\u56f0\u308a\u306e\u969b\u306f\u3001\u305c\u3072\u304a\u6c17\u8efd\u306b\u3054\u76f8\u8ac7\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p>\u307e\u305f\u3001IT\u30c4\u30fc\u30eb\u306e\u5c0e\u5165\u652f\u63f4\u3084IT\u5c0e\u5165\u88dc\u52a9\u91d1\u306e\u7533\u8acb\u30b5\u30dd\u30fc\u30c8\u3082\u884c\u3063\u3066\u304a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u8cb4\u65b9\u306e\u696d\u52d9\u6539\u5584\u3092\u5168\u529b\u3067\u30b5\u30dd\u30fc\u30c8\u3044\u305f\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p><a href=\"https:\/\/84office.jp\/contact\/\">\u304a\u554f\u3044\u5408\u308f\u305b\u306f\u3053\u3061\u3089<\/a><\/p>\n<\/div><\/div>\n\n\n\n\n","protected":false},"excerpt":{"rendered":"<p>In our previous article, we covered how to remove duplicate data in Google Sheets. This time, we\u2019ll focus on h [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17009,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"swell_btn_cv_data":"","_locale":"en_US","_original_post":"https:\/\/84office.jp\/?p=16091","footnotes":""},"categories":[12],"tags":[],"class_list":["post-16997","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-12","en-US"],"_links":{"self":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/16997","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/comments?post=16997"}],"version-history":[{"count":2,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/16997\/revisions"}],"predecessor-version":[{"id":17025,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/16997\/revisions\/17025"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media\/17009"}],"wp:attachment":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media?parent=16997"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/categories?post=16997"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/tags?post=16997"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}