{"id":28928,"date":"2023-05-05T23:10:30","date_gmt":"2023-05-05T21:10:30","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=28928"},"modified":"2024-04-19T19:15:11","modified_gmt":"2024-04-19T17:15:11","slug":"highlight-duplicates-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-duplicates-in-excel\/","title":{"rendered":"5 Epic Ways to Highlight Duplicates in Excel"},"content":{"rendered":"<p>In Excel, you are usually <strong>working with a large dataset, and encountering a duplicate value is really common<\/strong>. It may lead to <strong>incorrect <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formulas\" data-wpil-keyword-link=\"linked\">formulas<\/a> or calculations<\/strong> making the data inconsistent or inaccurate.<\/p>\n<p>You can easily <strong>spot and <\/strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/count-duplicates\/\" target=\"_blank\" rel=\"noopener\">highlight duplicates in<\/a> Excel using a really versatile feature &#8211; <strong>Conditionally Formatting<\/strong>. If you are not unfamiliar with this feature, it would be a good idea to go through it before we proceed. <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/analysis\/conditional-formatting\/\" target=\"_blank\">Click here<\/a><\/strong> to learn all about Conditional Formatting.<\/p>\n<p>In this article, you will be covering the following topics in detail &#8211;<\/p>\n<ul>\n<li><a href=\"#1\"><strong>Highlight Duplicates Values using Conditional Formatting<\/strong><\/a><\/li>\n<li><strong><a href=\"#2\">Highlight Duplicates expect 1st Occurence<\/a><\/strong><\/li>\n<li><a href=\"#3\"><strong>Highlight Duplicate Rows<\/strong><\/a><\/li>\n<li><a href=\"#5\"><strong>Remove Duplicates<\/strong><\/a><\/li>\n<li><a href=\"#4\"><strong>Put Unique Values in Another column<\/strong><\/a><\/li>\n<\/ul>\n<p>Let&#8217;s look at each of these topics one by one!<\/p>\n<h4>Download the Excel Workbook below to follow along and understand how to highlight duplicates in Excel &#8211;<\/h4>\n<h4><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Highlight-Duplicates-in-Excel.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel workbook<\/strong><\/span><span class=\"postTitle px-3\">Highlight-Duplicates-in-Excel.xlsx<\/span><\/a><\/h4>\n<p>&nbsp;<\/p>\n<p><strong><span id=\"1\" style=\"color: #ff0000!important\">Highlight Duplicates using Conditional Formatting<\/span><\/strong><\/p>\n<p>There is an<strong> in-built feature in conditional formatting<\/strong> that can be used to highlight duplicates. In this example, you have a list of employee names in Column A and you want to highlight the duplicate ones in red. Follow the steps below to apply it &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span> Select the range<\/strong> that contains duplicate values.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-172.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone wp-image-28935\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-172.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"187\" height=\"485\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-172.png 261w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-172-116x300.png 116w\" sizes=\"(max-width: 187px) 100vw, 187px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2:<\/span>\u00a0<\/strong>Go to the <strong>Home<\/strong> Tab &gt; Click on <strong>Conditional Formatting<\/strong> in the Styles group.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-173.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28936\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-173.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"1305\" height=\"162\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-173.png 1305w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-173-300x37.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-173-1024x127.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-173-768x95.png 768w\" sizes=\"(max-width: 1305px) 100vw, 1305px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3: <\/span><\/strong>Select <strong>Highlight Cells Rules<\/strong> &gt; <strong>Duplicate Values<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-174.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28937\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-174.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"1603\" height=\"621\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-174.png 1603w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-174-300x116.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-174-1024x397.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-174-768x298.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-174-1536x595.png 1536w\" sizes=\"(max-width: 1603px) 100vw, 1603px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 4:<\/span> <\/strong>In the Duplicate Values dialog box, select <strong>Duplicate<\/strong> and then the <strong>formatting <\/strong>that you want to apply. In this example, let&#8217;s select <strong>Light Red Fill with Dark Red Text<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-175.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28938\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-175.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"419\" height=\"163\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-175.png 419w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-175-300x117.png 300w\" sizes=\"(max-width: 419px) 100vw, 419px\" \/><\/a><\/p>\n<p><strong>STEP 5: <\/strong>Click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-176.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28939\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-176.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"417\" height=\"167\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-176.png 417w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-176-300x120.png 300w\" sizes=\"(max-width: 417px) 100vw, 417px\" \/><\/a><\/p>\n<p>You can see that <strong>all the duplicate values in the range will be highlighted<\/strong> based on the formatting that you have selected.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-177.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone wp-image-28940\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-177.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"232\" height=\"559\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-177.png 280w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-177-125x300.png 125w\" sizes=\"(max-width: 232px) 100vw, 232px\" \/><\/a><\/p>\n<p><em><strong>Pro Tip<\/strong> &#8211; In the dropdown, you can select <strong>Unique<\/strong> and all the unique values will be highlighted in the range.<\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-178.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28934\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-178.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"783\" height=\"674\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-178.png 783w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-178-300x258.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-178-768x661.png 768w\" sizes=\"(max-width: 783px) 100vw, 783px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span id=\"2\" style=\"color: #ff0000!important\">Highlight Duplicates expect 1st Occurence<\/span><\/strong><\/p>\n<p>In the previous example, what if you want to<strong> highlight all duplicates except the first occurrence<\/strong>? Excel has a way around that &#8211; you need to use a combination of the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/countif-formula-excel-2\/\" target=\"_blank\"><strong>COUNTIF<\/strong><\/a> function and conditional formatting.<\/p>\n<p>Follow the steps below &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span> Select the range<\/strong> that contains duplicate values.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-172.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone wp-image-28935\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-172.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"187\" height=\"485\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-172.png 261w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-172-116x300.png 116w\" sizes=\"(max-width: 187px) 100vw, 187px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2:<\/span>\u00a0<\/strong>Go to the <strong>Home<\/strong> Tab &gt; Click on <strong>Conditional Formatting<\/strong> in the Styles group.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-173.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28936\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-173.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"1305\" height=\"162\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-173.png 1305w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-173-300x37.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-173-1024x127.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-173-768x95.png 768w\" sizes=\"(max-width: 1305px) 100vw, 1305px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3: <\/span><\/strong>Go to <strong>New Rule<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-195.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28956\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-195.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"1370\" height=\"592\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-195.png 1370w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-195-300x130.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-195-1024x442.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-195-768x332.png 768w\" sizes=\"(max-width: 1370px) 100vw, 1370px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 4: <\/span><\/strong>In the New Formatting Rule dialog box, select<strong> Use a formula to determine which cells to format.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-179.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28948\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-179.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"637\" height=\"454\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-179.png 637w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-179-300x214.png 300w\" sizes=\"(max-width: 637px) 100vw, 637px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><b>STEP 5: <\/b><\/span><strong>Enter the following formula<\/strong> in the Edit Rule Description section &#8211;<\/p>\n<p><strong>=COUNTIF($A$2:A2,A2)&gt;1<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-190.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28952\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-190.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"638\" height=\"454\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-190.png 638w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-190-300x213.png 300w\" sizes=\"(max-width: 638px) 100vw, 638px\" \/><\/a><\/p>\n<p>Here, we are using a<strong> mixed reference range ($A$2:A2)<\/strong> -where the first cell in the reference is locked ($A$2) and the second range is left relative (A2). As you copy the formula down, the<strong> range will keep accommodating a new row<\/strong>. So, the COUNTIF formula will check values from the first location ($A$2) till the current location (say, A5) and will avoid the values below (from A6 to A32).<\/p>\n<p>For example, when COUNTIF is running the formula in cell A15, it will count the occurrence of &#8220;James Didn&#8217;t&#8221; from A2 to A15 and will display the result i.e. 2. It will not take into consideration the names mentioned in the range A16 to A32.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-193.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28955\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-193.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"555\" height=\"703\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-193.png 555w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-193-237x300.png 237w\" sizes=\"(max-width: 555px) 100vw, 555px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 6: <\/span><\/strong>Click on the <strong>Format<\/strong> button.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-191.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28953\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-191.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"636\" height=\"455\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-191.png 636w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-191-300x215.png 300w\" sizes=\"(max-width: 636px) 100vw, 636px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 7: <\/span><\/strong>Go to the <strong>Fill<\/strong> tab and select a <strong>light red color<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-182.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28949\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-182.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"673\" height=\"663\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-182.png 673w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-182-300x296.png 300w\" sizes=\"(max-width: 673px) 100vw, 673px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 8: <\/span><\/strong>Go to the <strong>Font<\/strong> tab and select a <strong>red<\/strong> color.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-183.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28950\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-183.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"677\" height=\"675\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-183.png 677w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-183-300x300.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-183-150x150.png 150w\" sizes=\"(max-width: 677px) 100vw, 677px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 8: <\/span><\/strong>Double-check the formatting for duplicates in the <strong>Preview<\/strong> section and press <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-192.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28954\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-192.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"640\" height=\"456\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-192.png 640w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-192-300x214.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>All the duplicates except the first occurrence has been highlighted in red font and light red fill.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-186.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28951\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-186.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"241\" height=\"673\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-186.png 241w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-186-107x300.png 107w\" sizes=\"(max-width: 241px) 100vw, 241px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span id=\"3\" style=\"color: #ff0000!important\">Highlight Duplicate Rows<\/span><\/strong><\/p>\n<p>Until now, we analyzed and highlighted duplicates based on values entered in a cell. The<strong> in-built feature of conditional formatting looks for value cell by cell <\/strong>only. Now, we<strong> want to look at the entire row&#8217;s content<\/strong> and then check for duplicates.<\/p>\n<p>In this example, we want to<strong> highlight a row only when values in all three columns are the same<\/strong> for any 2 rows.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-196.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone wp-image-28957\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-196.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"275\" height=\"534\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-196.png 349w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-196-154x300.png 154w\" sizes=\"(max-width: 275px) 100vw, 275px\" \/><\/a><\/p>\n<p>We will be using the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/concat-formula-in-excel\/\" target=\"_blank\"><strong>CONCAT<\/strong><\/a> function to create a helper column that will help us in highlighting duplicate rows. Follow the steps below to highlight duplicate rows &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span> <\/strong>Go to cell D2 and enter the <strong>CONCAT<\/strong> function.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-197.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28959\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-197.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"594\" height=\"693\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-197.png 594w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-197-257x300.png 257w\" sizes=\"(max-width: 594px) 100vw, 594px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2:<\/span> Select all three cells <\/strong>that you want to combine. and copy the formula down.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-199.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28960\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-199.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"677\" height=\"719\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-199.png 677w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-199-282x300.png 282w\" sizes=\"(max-width: 677px) 100vw, 677px\" \/><\/a><\/p>\n<p>We will be using range A2:C32 to highlight duplicates and range D2:D32 to check for duplicates.<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3:<\/span> Select the range <\/strong>where you want to<strong> highlight duplicates<\/strong> i.e. A2:C32.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-200.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28961\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-200.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"547\" height=\"689\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-200.png 547w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-200-238x300.png 238w\" sizes=\"(max-width: 547px) 100vw, 547px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 4:<\/span> <\/strong>Go to <strong>Home<\/strong> &gt; <strong>Conditional Formatting<\/strong> &gt; <strong>New Rule<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-204.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28964\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-204.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"1425\" height=\"619\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-204.png 1425w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-204-300x130.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-204-1024x445.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-204-768x334.png 768w\" sizes=\"(max-width: 1425px) 100vw, 1425px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 5:<\/span> <\/strong>In the New Formatting Rule dialog box, enter the following <strong>formula<\/strong> &#8211;<\/p>\n<p><strong>=COUNTIF($D$2:D32,$D2)&gt;1<\/strong><\/p>\n<p>Now, select the <strong>formatting<\/strong> that you want and press <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-203.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28963\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-203.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"637\" height=\"453\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-203.png 637w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-203-300x213.png 300w\" sizes=\"(max-width: 637px) 100vw, 637px\" \/><\/a><\/p>\n<p>All the duplicate rows have been highlighted.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-202.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28962\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-202.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"715\" height=\"719\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-202.png 715w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-202-298x300.png 298w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-202-150x150.png 150w\" sizes=\"(max-width: 715px) 100vw, 715px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span id=\"5\" style=\"color: #ff0000!important\"> Remove Duplicates<\/span><\/strong><\/p>\n<p>Instead of highlighting duplicates in the list, you may sometimes want to simply remove those duplicates from the list. Let\u2019s see how it can be done:<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span> <\/strong>Select the range containing duplicate values.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-208.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28969\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-208.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"321\" height=\"662\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-208.png 321w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-208-145x300.png 145w\" sizes=\"(max-width: 321px) 100vw, 321px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2: <\/span><\/strong>Go to <b>Data\u00a0<\/b>&gt;\u00a0<strong>Remove Duplicates.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-209.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28970\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-209.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"1712\" height=\"171\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-209.png 1712w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-209-300x30.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-209-1024x102.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-209-768x77.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-209-1536x153.png 1536w\" sizes=\"(max-width: 1712px) 100vw, 1712px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3: <\/span><\/strong>In the dialog box, <strong>check My data has headers<\/strong> and click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-210.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28971\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-210.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"430\" height=\"356\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-210.png 430w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-210-300x248.png 300w\" sizes=\"(max-width: 430px) 100vw, 430px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 4: <\/span>Excel sends an alert<\/strong> stating the number of duplicates that have been removed and the remaining number of unique values. Click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-211.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28972\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-211.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"777\" height=\"144\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-211.png 777w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-211-300x56.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-211-768x142.png 768w\" sizes=\"(max-width: 777px) 100vw, 777px\" \/><\/a><\/p>\n<p>All the duplicates have been removed and the list now contains only unique values.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-212.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28973\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-212.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"448\" height=\"716\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-212.png 448w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-212-188x300.png 188w\" sizes=\"(max-width: 448px) 100vw, 448px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span id=\"4\" style=\"color: #ff0000!important\">Put Unique Values in Another Column<\/span><\/strong><\/p>\n<p>What if we don&#8217;t want to highlight duplicates or remove them, we simply want out the <strong>unique values in another column<\/strong>?<\/p>\n<p>Excel has a function for this as well- <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/unique-formula-in-excel\/\" target=\"_blank\" rel=\"nofollow noopener\"><strong>UNIQUE<\/strong><\/a>. If you are unable to find this formula, you may be using an older version of Excel. <a href=\"https:\/\/www.microsoft.com\/en-in\/microsoft-365\/business\/compare-all-microsoft-365-business-products-b?ef_id=_k_CjwKCAjwo7iiBhAEEiwAsIxQEehdDN_criHe_4ExRceDCI4I_VeJP3vrFq4dymoBxIiXAlWK2RVbShoCcHQQAvD_BwE_k_&amp;OCID=AIDcmm409lj8ne_SEM__k_CjwKCAjwo7iiBhAEEiwAsIxQEehdDN_criHe_4ExRceDCI4I_VeJP3vrFq4dymoBxIiXAlWK2RVbShoCcHQQAvD_BwE_k_&amp;gclid=CjwKCAjwo7iiBhAEEiwAsIxQEehdDN_criHe_4ExRceDCI4I_VeJP3vrFq4dymoBxIiXAlWK2RVbShoCcHQQAvD_BwE\" target=\"_blank\" rel=\"nofollow noopener\"><strong>Click here<\/strong><\/a> to download Excel 365 and enjoy the benefits of using this amazing function.<\/p>\n<p>In this example, we have a list of names in column A that contains duplicates. We want to get a list of unique names in column B without making any change in column A. Let\u2019s see how it can be done.<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span> <\/strong>Enter the <strong>UNIQUE<\/strong> function in cell B2.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-205.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28966\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-205.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"566\" height=\"724\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-205.png 566w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-205-235x300.png 235w\" sizes=\"(max-width: 566px) 100vw, 566px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2:<\/span> Select the data<\/strong> from which you want to remove duplicates.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-206.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28967\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-206.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"551\" height=\"718\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-206.png 551w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-206-230x300.png 230w\" sizes=\"(max-width: 551px) 100vw, 551px\" \/><\/a><\/p>\n<p>All the unique names will be listed in column B.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-207.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"5 Epic Ways to Highlight Duplicates in Excel\" class=\"alignnone size-full wp-image-28968\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-207.png\" alt=\"5 Epic Ways to Highlight Duplicates in Excel\" width=\"507\" height=\"677\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-207.png 507w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-207-225x300.png 225w\" sizes=\"(max-width: 507px) 100vw, 507px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>In this article, we have learned how to highlight duplicate values and rows, how to highlight all except 1st occurrence of duplicates, remove duplicates and get unique values in a new column.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/101-excel-tips-e-book-youtube-channel\" target=\"_blank\"><strong>Click here<\/strong><\/a> for The BEST Microsoft Excel\u00a0<em>Tips<\/em>\u00a0&amp;\u00a0<em>Tricks<\/em>\u00a0EVER, ranging from Formatting, Macros, Formulas, Tables, Pivot Tables, Working with Data plus Many More!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Excel, you are usually working with a large dataset, and encountering a duplicate value is really common. It may lead to incorrect formulas or calculations making the data inconsistent or inaccurate. You can easily spot and highlight duplicates in Excel using a really versatile feature &#8211; Conditionally Formatting. If you are not unfamiliar with [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":29202,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"5 Epic Ways to Highlight Duplicates in Excel","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[35,10],"tags":[1219,1220,1218],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/28928"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=28928"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/28928\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/29202"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=28928"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=28928"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=28928"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}