{"id":116,"date":"2024-01-07T18:54:12","date_gmt":"2024-01-07T10:54:12","guid":{"rendered":"http:\/\/excelchamp.net\/?p=116"},"modified":"2024-01-07T19:24:27","modified_gmt":"2024-01-07T11:24:27","slug":"how-to-find-duplicates-in-excel-quickly","status":"publish","type":"post","link":"https:\/\/www.excelchamp.net\/how-to-find-duplicates-in-excel-quickly\/","title":{"rendered":"How to Find &#038; Remove Duplicates in Excel Quickly"},"content":{"rendered":"<p>With thousands of rows in today&#8217;s spreadsheets, it is virtually impossible for anyone to spot a duplicate value or duplicate row in Excel visually or manually. But you&#8217;ll be getting the wrong picture, and your analysis will be wrong until you remove the duplicates. So it is extremely important to De-Duplicate your Data carefully in the Excel sheet, before you begin your data analysis.<\/p>\n<p>Fortunately, since Microsoft Excel 2007, it has been extremely easy to find Duplicates, and Remove them in a single click.<\/p>\n<p><strong>In this step by step article, and a tutorial video on How to Find Duplicates in Excel, and How to Remove Duplicates in Excel Sheet, you&#8217;ll learn a couple of hidden gems of Excel features and functionality.<\/strong><\/p>\n<p>With Office 365, and all the way back to Microsoft Excel 2007, there has been steady enhancements in different Excel versions in terms of finding and tracking duplicates, and even removing them.<\/p>\n<h3>Now it is extremely easy to spot duplicates, and there are multiple ways to find duplicates or eliminate duplicates from your Excel workbooks and worksheets.<\/h3>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/eAKl5hi4XDQ?si=16E7jztwPyW1y14C\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>Let&#8217;s look at How to Find Duplicates in Excel first. Then we will see how to remove duplicates in Excel sheet. And we will also show you Excel formulas to remove duplicates. Use any of these methods to quickly remove duplicate cells in Excel.<\/p>\n<h2><strong>Step 1: Spot a duplicate value, and get it to change its color automatically<br \/>\n<\/strong><\/h2>\n<p>In this simple and easiest method to find duplicate rows in Excel, we make use of <strong>Conditional Formatting in Excel<\/strong>, available on the <strong>Home<\/strong> Tab.<\/p>\n<ul>\n<li>Simply select the data range where you want to spot any duplicate values, and then click on <em>Conditional Formatting<\/em>. A drop down menu of choices appears. Select the first choice &#8211; <strong>Highlight Cell Rules<\/strong>. Then select the Last option &#8211;<strong>Duplicate Values<\/strong>. <strong><strong>The short cut key combination is Alt +H L H D.<\/strong><\/strong><a href=\"https:\/\/i0.wp.com\/excelchamp.net\/wp-content\/uploads\/2013\/11\/highlight_cells_duplicate_value.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-121 aligncenter\" src=\"https:\/\/i0.wp.com\/excelchamp.net\/wp-content\/uploads\/2013\/11\/highlight_cells_duplicate_value.jpg?resize=358%2C412\" alt=\"highlight_cells_duplicate_value\" width=\"358\" height=\"412\" data-recalc-dims=\"1\" \/><\/a><\/li>\n<\/ul>\n<h2><strong>Step 2. Select your favorite color to highlight the duplicate values.<\/strong><\/h2>\n<p><strong>Here I have chosen the Light Red color.<\/strong><img decoding=\"async\" class=\"size-full wp-image-120 aligncenter\" src=\"https:\/\/i0.wp.com\/excelchamp.net\/wp-content\/uploads\/2013\/11\/duplicate_values_popup.png?resize=365%2C149\" alt=\"duplicate_values_popup\" width=\"365\" height=\"149\" data-recalc-dims=\"1\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2><strong>Step 3. Both the duplicate values are now highlighted.<\/strong><\/h2>\n<p><a href=\"https:\/\/i0.wp.com\/excelchamp.net\/wp-content\/uploads\/2013\/11\/duplicates_highlighted.png\"><img decoding=\"async\" class=\"size-full wp-image-119 aligncenter\" src=\"https:\/\/i0.wp.com\/excelchamp.net\/wp-content\/uploads\/2013\/11\/duplicates_highlighted.png?resize=155%2C281\" alt=\"finding duplicate values in Microsoft Excel\" width=\"155\" height=\"281\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>There you are. A quick and nifty way to find the duplicate values in any column, quickly.<\/p>\n\t\t<div data-elementor-type=\"section\" data-elementor-id=\"705\" class=\"elementor elementor-705 elementor-bc-flex-widget\" data-elementor-post-type=\"elementor_library\">\n\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7f5e9af elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7f5e9af\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f6d494f\" data-id=\"f6d494f\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-db6834f elementor-widget elementor-widget-text-editor\" data-id=\"db6834f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div style=\"background-color: #ffffcc; color: black; border: thin Black; border-style: none; align = center; line-height: 27px; width: 95%; padding: 20px 30px 10px;\"><p style=\"text-align: center;\"><span style=\"color: #0000cd;\"><strong>Want to Improve Your Excel Skills?<\/strong><\/span><\/p><p style=\"text-align: center;\"><span style=\"color: #0000cd;\">Learn the Key Features of Excel Quickly &amp; Easily, by <\/span><span style=\"color: #0000cd;\">Joining the<br \/> <a href=\"https:\/\/www.trueducate.com\/courses\/basic-excel-online\/\" target=\"_blank\" rel=\"noopener\"><u><strong>Online Training<\/strong> on <\/u><strong><u>Basic \/ Intermediate Excel<\/u>.<\/strong><\/a><\/span><\/p><p style=\"text-align: center;\"><span style=\"color: #0000cd;\">To Get Most out of Excel, Learn the\u00a0 <b><u><a href=\"https:\/\/www.trueducate.com\/courses\/excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\">Pivot Table techniques in our<br \/> Pivot Table Masterclass Training<\/a><\/u><\/b><a href=\"https:\/\/www.trueducate.com\/courses\/excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\"><strong>!<\/strong><\/a><\/span><\/p><\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t\n<p><strong>This method uses the EXACT duplicates to highlight.<\/strong><\/p>\n<blockquote><p>If you want to show partial matches in terms of duplicates or similar to duplicates, you can use another interesting technique.<\/p><\/blockquote>\n<h2>Using Conditional Formatting in Excel to Find Partial Matches<\/h2>\n<p>Here we use the &#8220;<em><strong>Text That Contains<\/strong><\/em>&#8221; setting under <em><strong>Conditional Formatting &gt; Highlight Cell Rules &gt;<\/strong><\/em><\/p>\n<p>With this setting, and keying in any value, it will be able to find Partial Matches of values.<\/p>\n<figure id=\"attachment_2188\" aria-describedby=\"caption-attachment-2188\" style=\"width: 556px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2188\" src=\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2013\/11\/conditional_formatting_Text_that_contains.png?resize=566%2C489&#038;ssl=1\" alt=\"Conditional Formatting - Text That Contains to Identify Partial Matches\" width=\"566\" height=\"489\" srcset=\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2013\/11\/conditional_formatting_Text_that_contains.png?w=566&amp;ssl=1 566w, https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2013\/11\/conditional_formatting_Text_that_contains.png?resize=300%2C259&amp;ssl=1 300w\" sizes=\"(max-width: 566px) 100vw, 566px\" data-recalc-dims=\"1\" \/><figcaption id=\"caption-attachment-2188\" class=\"wp-caption-text\">Conditional Formatting &#8211; Text That Contains to Identify Partial Matches<\/figcaption><\/figure>\n<h2>I am searching for names that contain the word &#8220;Ram&#8221;.<\/h2>\n<figure id=\"attachment_2189\" aria-describedby=\"caption-attachment-2189\" style=\"width: 1014px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-2189\" src=\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2013\/11\/duplicate_values_partial_match.png?resize=1024%2C618&#038;ssl=1\" alt=\"Partial Match in searching for Duplicate Values in Excel\" width=\"1024\" height=\"618\" srcset=\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2013\/11\/duplicate_values_partial_match.png?resize=1024%2C618&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2013\/11\/duplicate_values_partial_match.png?resize=300%2C181&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2013\/11\/duplicate_values_partial_match.png?resize=768%2C463&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2013\/11\/duplicate_values_partial_match.png?w=1074&amp;ssl=1 1074w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" data-recalc-dims=\"1\" \/><figcaption id=\"caption-attachment-2189\" class=\"wp-caption-text\">Partial Match in searching for Duplicate Values in Excel<\/figcaption><\/figure>\n<p>As you can see, Ram Kumar was highlighted, due to Ram, but Krish was also highlighted, because the full name contains the word &#8220;ram&#8221; in the last name, Venkataraman.<\/p>\n<blockquote><p><strong>This way, you can pick partial matches to be highlighted in Excel, using Conditional Formatting technique.<\/strong><\/p><\/blockquote>\n<p>And if you want to do it again and again with different values to find, it is better to set a cell to the value being found. Then set the Conditional Formatting to search for the value in that cell.<\/p>\n<p>I have demonstrated this in the <strong><a href=\"https:\/\/www.youtube.com\/watch?v=eAKl5hi4XDQ\" target=\"_blank\" rel=\"noopener\">video on How to Find &amp; Remove Duplicates in Excel<\/a><\/strong>. Click to watch it and see how this is done properly. This guided video will help you in identifying and eliminating duplicates easily.<\/p>\n<h2>How to Remove Duplicates in Excel?<\/h2>\n<p><strong>We will talk about another <a title=\"Removing Duplicate Values in Excel\" href=\"http:\/\/excelchamp.net\/removing-duplicate-values-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">nifty way to eliminate duplicates in Excel<\/a>, once for all, in the next article.<br \/>\n<\/strong><\/p>\n<p>If you were to head to the <strong>Data<\/strong> Tab, and look under the <em><strong>Data Tools<\/strong><\/em> group, you&#8217;ll find the &#8220;<em><strong>Remove Duplicates<\/strong><\/em>&#8221; button hiding there. Some versions of Excel show a small icon, others show the full word, and some versions have a huge icon, and the words &#8220;<strong>Remove Duplicates<\/strong>&#8221; visible in full.<\/p>\n<p>Check carefully to identify the button in your version of Excel. But all Excel versions since Excel 2007 have this<strong> button to Remove Duplicates<\/strong>.<\/p>\n<h2>STEPS TO REMOVE DUPLICATE ROWS IN EXCEL<\/h2>\n<p>With this option, simply select the entire data range, and then click on this <em><strong>&#8220;Remove Duplicates&#8221;<\/strong><\/em> button.<strong> It will identify rows that are EXACT DUPLICATES, and simply remove them.<\/strong><\/p>\n<p>Then Excel will notify you that <em><strong>X number of rows containing duplicates were found, and Removed<\/strong><\/em>.<\/p>\n<p>However, this Remove Duplicates button click <strong style=\"font-style: italic;\">WILL NOT<\/strong> show you which records were removed. \ud83d\ude41<\/p>\n<blockquote><p><strong><em>Some people find this feature a bit of a risk. Thus, it is better to use Conditional Formatting technique described earlier to SEE the Duplicates visually, BEFORE REMOVING them.<\/em><\/strong><\/p><\/blockquote>\n<p>With these 2 techniques, you can <strong>FIND<\/strong> the Duplicates, <strong>SEE<\/strong> them visually, <strong>DOUBLE CHECK<\/strong> that the correct ones are highlighted, and then only <strong>REMOVE<\/strong> the Duplicates.<\/p>\n<blockquote><p><strong>Better Safe than Sorry!<\/strong><\/p><\/blockquote>\n<h2>How to Compare Two Excel Sheets for Duplicates and Highlight the Duplicate Data<\/h2>\n<p>Comparing two Excel sheets for duplicates and highlighting the duplicate data can be done using a few different methods. Here&#8217;s a step-by-step instruction for a couple of common approaches:<\/p>\n<h3>Method 1: Using Conditional Formatting in Excel<\/h3>\n<ol>\n<li><strong>Open Your Excel Workbook<\/strong>: Make sure both sheets you want to compare are in the same workbook.<\/li>\n<li><strong>Select the Range in the First Sheet<\/strong>: Click on the first cell of the range you want to compare and drag to select the entire range.<\/li>\n<li><strong>Go to Conditional Formatting<\/strong>: On the Home tab, in the Styles group, click on &#8216;Conditional Formatting&#8217;.<\/li>\n<li><strong>New Rule<\/strong>: Click on &#8216;New Rule&#8217;.<\/li>\n<li><strong>Use a Formula to Determine Which Cells to Format<\/strong>: Select this option.<\/li>\n<li><strong>Enter Comparison Formula<\/strong>:\n<ul>\n<li>Suppose you are comparing Sheet1 to Sheet2. The formula will look something like this:\n<div class=\"bg-black rounded-md\">\n<div class=\"flex items-center relative text-gray-200 bg-gray-800 dark:bg-token-surface-primary px-4 py-2 text-xs font-sans justify-between rounded-t-md\"><\/div>\n<div class=\"p-4 overflow-y-auto\"><code class=\"!whitespace-pre hljs language-scss\">=<span class=\"hljs-built_in\">COUNTIF<\/span>(Sheet2!A:A, A1)&gt;<span class=\"hljs-number\">0<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<p>This formula assumes you&#8217;re comparing column A of both sheets. Adjust the range (e.g., <code>A:A<\/code> or <code>B:B<\/code>) and cell (e.g., <code>A1<\/code>, <code>B1<\/code>) to suit your data.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Set Format<\/strong>: Click on &#8216;Format&#8217;, choose a highlighting color under the &#8216;Fill&#8217; tab, and click OK.<\/li>\n<li><strong>Apply and OK<\/strong>: Click OK to apply the conditional formatting. Duplicates will be highlighted in the chosen color.<\/li>\n<li><strong>Repeat for the Second Sheet<\/strong>: Now, do the same for the range in the second sheet you&#8217;re comparing.<\/li>\n<\/ol>\n<h3>Method 2: Using Excel&#8217;s &#8216;Remove Duplicates&#8217; Feature<\/h3>\n<ol>\n<li><strong>Copy Data to a New Sheet<\/strong>: If you want to keep the original sheets unchanged, copy the data from both sheets into a new sheet, one below the other.<\/li>\n<li><strong>Select the Combined Data<\/strong>: Click on the first cell and drag to select the entire range.<\/li>\n<li><strong>Data Tab<\/strong>: Go to the &#8216;Data&#8217; tab on the ribbon.<\/li>\n<li><strong>Remove Duplicates<\/strong>: Click on &#8216;Remove Duplicates&#8217;.<\/li>\n<li><strong>Choose Columns<\/strong>: In the Remove Duplicates dialog box, choose the columns you want to check for duplicate information, then click OK.<\/li>\n<li><strong>Duplicates are Removed<\/strong>: Excel will remove duplicate rows and show a message indicating how many duplicates were removed and how many unique values remain.<\/li>\n<li><strong>Highlight Original Data<\/strong>: You can then manually or using conditional formatting (as described in Method 1) highlight these duplicates in your original sheets.<\/li>\n<\/ol>\n<h2>Using Excel Formulas to Find Duplicate Data in Excel Sheets<\/h2>\n<p><strong>The VLOOKUP, INDEX, and MATCH functions in Excel can be very useful for identifying duplicates across sheets or within a sheet.<\/strong><\/p>\n<p>However, it&#8217;s important to note that these functions can identify duplicates, but they don&#8217;t directly remove them. You should generally use these functions in combination with conditional formatting to highlight duplicates or with other Excel features to remove them. Let&#8217;s go through how to use each function for identifying duplicates in Excel Sheets:<\/p>\n<h3>VLOOKUP to Identify Duplicates<\/h3>\n<p>The VLOOKUP function searches for a value in the first column of a range and returns a value in the same row from a specified column.<\/p>\n<ol>\n<li><strong>Select a Cell for the VLOOKUP Result<\/strong>: Click on a cell where you want to display the result (e.g., next to your data).<\/li>\n<li><strong>Enter the VLOOKUP Formula<\/strong>:\n<ul>\n<li>Example formula: <strong><code>=VLOOKUP(A2, Sheet2!A:A, 1, FALSE)<\/code><\/strong><\/li>\n<li>This formula checks if the value in A2 of the current sheet exists in column A of Sheet2.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Copy the Formula Down<\/strong>: Drag the fill handle down to copy the formula to other cells.<\/li>\n<li><strong>Identify Duplicates<\/strong>: If VLOOKUP finds a match, it will display the matching value; if not, it will show an error. You can use conditional formatting to highlight cells where VLOOKUP doesn&#8217;t return an error, indicating a duplicate.<\/li>\n<\/ol>\n<h3>INDEX and MATCH to Identify Duplicates<\/h3>\n<p>The combination of INDEX and MATCH is often used as an alternative to VLOOKUP. MATCH finds the position of a value in a range, and INDEX returns a value at a given position in a range.<\/p>\n<ol>\n<li><strong>Select a Cell for the Result<\/strong>: Choose where you want the result to appear.<\/li>\n<li><strong>Enter the INDEX-MATCH Formula<\/strong>:\n<ul>\n<li>Example formula: <strong><code>=INDEX(Sheet2!A:A, MATCH(A2, Sheet2!A:A, 0))<\/code><\/strong><\/li>\n<li>This formula searches for the value in A2 of the current sheet in column A of Sheet2 and returns the corresponding value.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Copy the Formula<\/strong>: Drag down the formula as needed.<\/li>\n<li><strong>Highlight Duplicates<\/strong>: Use conditional formatting to highlight cells where INDEX-MATCH returns a value, indicating a duplicate.<\/li>\n<\/ol>\n<h3>Removing Duplicates Using a Formula<\/h3>\n<p>While there&#8217;s no direct formula to remove duplicates cells in Excel, you can use a combination of functions to create a list that excludes duplicates. One common approach is using the IF, COUNTIF, and an array formula.<\/p>\n<ol>\n<li><strong>Create a New Column<\/strong>: In a new column next to your data, you&#8217;re going to enter a formula that will flag duplicates.<\/li>\n<li><strong>Enter the Array Formula<\/strong>:\n<ul>\n<li>Example formula: <strong><code>=IF(COUNTIF($A$1:A2, A2)=1, A2, \"\")<\/code><\/strong><\/li>\n<li>This formula checks if the current value in column A has appeared before. If it&#8217;s the first occurrence, it shows the value; otherwise, it shows an empty string.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Enter as an Array Formula<\/strong>: After typing the formula, press <strong><code>Ctrl<\/code> + <code>Shift<\/code> + <code>Enter<\/code><\/strong> instead of just <strong><code>Enter<\/code><\/strong>. This converts it into an array formula.<\/li>\n<li><strong>Copy Down the Formula<\/strong>: Drag the fill handle down to apply this to your entire data set.<\/li>\n<li><strong>Filter or Sort<\/strong>: Now, you can filter or sort this new column to separate unique values from duplicates.<\/li>\n<\/ol>\n<blockquote><p>Remember, these methods will help you identify and segregate duplicates, but to actually remove them from your data, you might have to do some manual data management or use the &#8220;<strong>Remove Duplicates<\/strong>&#8221; feature in Excel that we discussed earlier.<\/p><\/blockquote>\n<p>And this brings us to a close of this article. I hope that with these techniques, you can pick up duplicates in your data in Excel or remove them, as you wish.<\/p>\n<blockquote><p><strong>PRO TIP:<\/strong> <em>Do remember to watch the Video, for <a href=\"https:\/\/www.youtube.com\/watch?v=eAKl5hi4XDQ\" target=\"_blank\" rel=\"noopener\">how to identify values that start with a particular Text, or End with a particular text<\/a>. It is highlighted in the Video in detail<\/em>, and can be very handy.<\/p><\/blockquote>\n<h3>Do you have a Duplicates related question in Excel?<\/h3>\n<p>Simply write to us, and our Excel experts will try to help you out. <a href=\"https:\/\/www.excelchamp.net\/contact-us\/\">Write to us at the Contact Us page on this website<\/a>.<\/p>\n<p><strong>You may find these resources useful:<\/strong><\/p>\n<ul>\n<li><a title=\"View All Formulas in Excel with a Single Click\" href=\"http:\/\/excelchamp.net\/view-all-formulas-in-excel-with-a-single-click\/\" target=\"_blank\" rel=\"noopener noreferrer\">View all Formulas in Excel in a Single Click<\/a><\/li>\n<li><a title=\"Creating a Two Axis Chart in Excel 2007 \/ Excel 2010 \/ Excel 2013\" href=\"http:\/\/excelchamp.net\/creating-a-two-axis-chart-in-excel-2010\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Build a Two Axis Chart in Excel<\/a><\/li>\n<\/ul>\n<p>Cheers,<br \/>\n<strong>Vinai Prakash,<\/strong><br \/>\n<em>Founder of ExcelChamp.Net &amp; Master Trainer for all Excel Courses at ExcelChamp.<\/em><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/@ExcelChamp\" target=\"_blank\" rel=\"noopener\">Visit our ExcelChamp Channel on YouTube for more Excel Tips &amp; Tricks.<\/a><\/p>\n<p>Vinai is passionate about maximizing Excel to improve everyday productivity. He conducts Excel workshops in Singapore, Australia, Middle East. If you would like to engage him to <a title=\"About ExcelChamp\" href=\"http:\/\/excelchamp.net\/about-excelchamp\/\" target=\"_blank\" rel=\"noopener noreferrer\">train your staff in maximising Excel, do contact us<\/a>.<\/p>\n<p><strong>And <a href=\"https:\/\/www.excelchamp.net\/courses\/\" target=\"_blank\" rel=\"noopener\">join our Online Excel courses to learn Excel well, and become a Pro<\/a>.<\/strong><\/p>\n\t\t<div data-elementor-type=\"section\" data-elementor-id=\"514\" class=\"elementor elementor-514\" data-elementor-post-type=\"elementor_library\">\n\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-14e69bc6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"14e69bc6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-31f6f1ef\" data-id=\"31f6f1ef\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3b580a03 elementor-widget elementor-widget-heading\" data-id=\"3b580a03\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Are you facing any problem in using Excel?  Any Question?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2709bfb elementor-widget elementor-widget-text-editor\" data-id=\"2709bfb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong><span style=\"color: #ff9900;\"><span class=\"st\">You have come to the right place<\/span>. Tell us your needs. We&#8217;ll be glad to help you!<\/span><\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6e758d36 elementor-button-align-center elementor-widget elementor-widget-form\" data-id=\"6e758d36\" data-element_type=\"widget\" data-settings=\"{&quot;step_next_label&quot;:&quot;Next&quot;,&quot;step_previous_label&quot;:&quot;Previous&quot;,&quot;step_type&quot;:&quot;number_text&quot;,&quot;step_icon_shape&quot;:&quot;circle&quot;}\" data-widget_type=\"form.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<form class=\"elementor-form\" method=\"post\" name=\"Quick Enquiry\">\n\t\t\t<input type=\"hidden\" name=\"post_id\" value=\"514\"\/>\n\t\t\t<input type=\"hidden\" name=\"form_id\" value=\"6e758d36\"\/>\n\t\t\t<input type=\"hidden\" name=\"referer_title\" value=\"ExcelChamp\" \/>\n\n\t\t\t\n\t\t\t<div class=\"elementor-form-fields-wrapper elementor-labels-\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-text elementor-field-group elementor-column elementor-field-group-field_1 elementor-col-100 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-field_1\" class=\"elementor-field-label elementor-screen-only\">\n\t\t\t\t\t\t\t\tName\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<input size=\"1\" type=\"text\" name=\"form_fields[field_1]\" id=\"form-field-field_1\" class=\"elementor-field elementor-size-sm  elementor-field-textual\" placeholder=\"Name\" required=\"required\" aria-required=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-email elementor-field-group elementor-column elementor-field-group-field_2 elementor-col-100 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-field_2\" class=\"elementor-field-label elementor-screen-only\">\n\t\t\t\t\t\t\t\tEmail\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<input size=\"1\" type=\"email\" name=\"form_fields[field_2]\" id=\"form-field-field_2\" class=\"elementor-field elementor-size-sm  elementor-field-textual\" placeholder=\"Email\" required=\"required\" aria-required=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-textarea elementor-field-group elementor-column elementor-field-group-field_3 elementor-col-100 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-field_3\" class=\"elementor-field-label elementor-screen-only\">\n\t\t\t\t\t\t\t\tQuestion\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t<textarea class=\"elementor-field-textual elementor-field  elementor-size-sm\" name=\"form_fields[field_3]\" id=\"form-field-field_3\" rows=\"3\" placeholder=\"Question\" required=\"required\" aria-required=\"true\"><\/textarea>\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-recaptcha_v3 elementor-field-group elementor-column elementor-field-group-field_9c3764f elementor-col-100 recaptcha_v3-bottomright\">\n\t\t\t\t\t<div class=\"elementor-field\" id=\"form-field-field_9c3764f\"><div class=\"elementor-g-recaptcha\" data-sitekey=\"6Let3GkeAAAAABfVEzbSL0GVAq2ejuG2VI3tGriG\" data-type=\"v3\" data-action=\"Form\" data-badge=\"bottomright\" data-size=\"invisible\"><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-group elementor-column elementor-field-type-submit elementor-col-100 e-form__buttons\">\n\t\t\t\t\t<button type=\"submit\" class=\"elementor-button elementor-size-sm elementor-animation-grow\">\n\t\t\t\t\t\t<span >\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-align-icon-right elementor-button-icon\">\n\t\t\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-arrow-right\"><\/i>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Help Me Out<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/button>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/form>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t\n<p><a href=\"https:\/\/www.excelchamp.net\/excel-lookup-functions-to-save-time\/\">Master Excel Lookup Functions like VLOOKUP, HLOOKUP, INDEX, MATCH, OFFSET<\/a><\/p>\n<p><a href=\"https:\/\/www.excelchamp.net\/how-to-refresh-pivot-table-in-excel\/\">How to Refresh a Pivot Table (Manually or Automatically)<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>With thousands of rows in today&#8217;s spreadsheets, it is virtually impossible for anyone to spot a duplicate value or duplicate row in Excel visually or manually. But you&#8217;ll be getting the wrong picture, and your analysis will be wrong until you remove the duplicates. So it is extremely important to De-Duplicate your Data carefully in &#8230; <a title=\"How to Find &#038; Remove Duplicates in Excel Quickly\" class=\"read-more\" href=\"https:\/\/www.excelchamp.net\/how-to-find-duplicates-in-excel-quickly\/\" aria-label=\"More on How to Find &#038; Remove Duplicates in Excel Quickly\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":2193,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"generate_page_header":"","footnotes":"","_jetpack_memberships_contains_paid_content":false},"categories":[5,6,8],"tags":[33,39,58,74],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Find Duplicates in Excel Quickly<\/title>\n<meta name=\"description\" content=\"Find out several ways to find duplicates in Excel. Then Eliminate them, or just highlight them. Many simple and useful tips on Excel at ExcelChamp founder Vinai Prakash&#039;s blog.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.excelchamp.net\/how-to-find-duplicates-in-excel-quickly\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Find Duplicates in Excel Quickly\" \/>\n<meta property=\"og:description\" content=\"Find out several ways to find duplicates in Excel. Then Eliminate them, or just highlight them. Many simple and useful tips on Excel at ExcelChamp founder Vinai Prakash&#039;s blog.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.excelchamp.net\/how-to-find-duplicates-in-excel-quickly\/\" \/>\n<meta property=\"og:site_name\" content=\"ExcelChamp\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/profile.php?id=100079767634794\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/profile.php?id=100079767634794\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-07T10:54:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-07T11:24:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash-e1654524348231.png?fit=331%2C314&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"331\" \/>\n\t<meta property=\"og:image:height\" content=\"314\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vinai Prakash\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vinai Prakash\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.excelchamp.net\/how-to-find-duplicates-in-excel-quickly\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.excelchamp.net\/how-to-find-duplicates-in-excel-quickly\/\"},\"author\":{\"name\":\"Vinai Prakash\",\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\"},\"headline\":\"How to Find &#038; Remove Duplicates in Excel Quickly\",\"datePublished\":\"2024-01-07T10:54:12+00:00\",\"dateModified\":\"2024-01-07T11:24:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.excelchamp.net\/how-to-find-duplicates-in-excel-quickly\/\"},\"wordCount\":1921,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\"},\"keywords\":[\"dedup excel\",\"eliminate duplicates\",\"finding duplicate values in Excel\",\"removing duplicates in excel\"],\"articleSection\":[\"Excel Functions\",\"Excel In-Built Functionality\",\"Excel Video Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.excelchamp.net\/how-to-find-duplicates-in-excel-quickly\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.excelchamp.net\/how-to-find-duplicates-in-excel-quickly\/\",\"url\":\"https:\/\/www.excelchamp.net\/how-to-find-duplicates-in-excel-quickly\/\",\"name\":\"How to Find Duplicates in Excel Quickly\",\"isPartOf\":{\"@id\":\"https:\/\/www.excelchamp.net\/#website\"},\"datePublished\":\"2024-01-07T10:54:12+00:00\",\"dateModified\":\"2024-01-07T11:24:27+00:00\",\"description\":\"Find out several ways to find duplicates in Excel. Then Eliminate them, or just highlight them. Many simple and useful tips on Excel at ExcelChamp founder Vinai Prakash's blog.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.excelchamp.net\/how-to-find-duplicates-in-excel-quickly\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.excelchamp.net\/how-to-find-duplicates-in-excel-quickly\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.excelchamp.net\/how-to-find-duplicates-in-excel-quickly\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.excelchamp.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Find Duplicates in Excel Quickly\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.excelchamp.net\/#website\",\"url\":\"https:\/\/www.excelchamp.net\/\",\"name\":\"ExcelChamp\",\"description\":\"Solving Everyday Problems With Excel\",\"publisher\":{\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.excelchamp.net\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\",\"name\":\"Vinai Prakash\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash.png?fit=487%2C720&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash.png?fit=487%2C720&ssl=1\",\"width\":487,\"height\":720,\"caption\":\"Vinai Prakash\"},\"logo\":{\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/image\/\"},\"description\":\"Vinai Prakash is the founder and master trainer of ExcelChamp.Net. Vinai has over 30 years of experience in using Excel, and is a Data Warehousing &amp; Business Intelligence Professional. Vinai has coached and trained over 30,000 professionals in using Excel, Power BI, Python, SQL, and regularly runs Excel Data Analysis, Excel Dashboard MasterClass, Excel for Beginners, Advanced Excel MasterClass online and all over the world. Vinai's Videos on YouTube channel and his blog articles and newsletters are read by thousands of subscribers all over the world. Vinai lives in Singapore with his wife and 2 kids.\",\"sameAs\":[\"https:\/\/ExcelChamp.Net\",\"https:\/\/www.facebook.com\/profile.php?id=100079767634794\",\"https:\/\/www.linkedin.com\/in\/vinaiprakash\/\",\"https:\/\/www.youtube.com\/user\/ExcelChamp\"],\"url\":\"https:\/\/www.excelchamp.net\/author\/ppfdd\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Find Duplicates in Excel Quickly","description":"Find out several ways to find duplicates in Excel. Then Eliminate them, or just highlight them. Many simple and useful tips on Excel at ExcelChamp founder Vinai Prakash's blog.","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:\/\/www.excelchamp.net\/how-to-find-duplicates-in-excel-quickly\/","og_locale":"en_US","og_type":"article","og_title":"How to Find Duplicates in Excel Quickly","og_description":"Find out several ways to find duplicates in Excel. Then Eliminate them, or just highlight them. Many simple and useful tips on Excel at ExcelChamp founder Vinai Prakash's blog.","og_url":"https:\/\/www.excelchamp.net\/how-to-find-duplicates-in-excel-quickly\/","og_site_name":"ExcelChamp","article_publisher":"https:\/\/www.facebook.com\/profile.php?id=100079767634794","article_author":"https:\/\/www.facebook.com\/profile.php?id=100079767634794","article_published_time":"2024-01-07T10:54:12+00:00","article_modified_time":"2024-01-07T11:24:27+00:00","og_image":[{"width":331,"height":314,"url":"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash-e1654524348231.png?fit=331%2C314&ssl=1","type":"image\/png"}],"author":"Vinai Prakash","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Vinai Prakash","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.excelchamp.net\/how-to-find-duplicates-in-excel-quickly\/#article","isPartOf":{"@id":"https:\/\/www.excelchamp.net\/how-to-find-duplicates-in-excel-quickly\/"},"author":{"name":"Vinai Prakash","@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba"},"headline":"How to Find &#038; Remove Duplicates in Excel Quickly","datePublished":"2024-01-07T10:54:12+00:00","dateModified":"2024-01-07T11:24:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.excelchamp.net\/how-to-find-duplicates-in-excel-quickly\/"},"wordCount":1921,"commentCount":0,"publisher":{"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba"},"keywords":["dedup excel","eliminate duplicates","finding duplicate values in Excel","removing duplicates in excel"],"articleSection":["Excel Functions","Excel In-Built Functionality","Excel Video Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.excelchamp.net\/how-to-find-duplicates-in-excel-quickly\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.excelchamp.net\/how-to-find-duplicates-in-excel-quickly\/","url":"https:\/\/www.excelchamp.net\/how-to-find-duplicates-in-excel-quickly\/","name":"How to Find Duplicates in Excel Quickly","isPartOf":{"@id":"https:\/\/www.excelchamp.net\/#website"},"datePublished":"2024-01-07T10:54:12+00:00","dateModified":"2024-01-07T11:24:27+00:00","description":"Find out several ways to find duplicates in Excel. Then Eliminate them, or just highlight them. Many simple and useful tips on Excel at ExcelChamp founder Vinai Prakash's blog.","breadcrumb":{"@id":"https:\/\/www.excelchamp.net\/how-to-find-duplicates-in-excel-quickly\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.excelchamp.net\/how-to-find-duplicates-in-excel-quickly\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.excelchamp.net\/how-to-find-duplicates-in-excel-quickly\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.excelchamp.net\/"},{"@type":"ListItem","position":2,"name":"How to Find Duplicates in Excel Quickly"}]},{"@type":"WebSite","@id":"https:\/\/www.excelchamp.net\/#website","url":"https:\/\/www.excelchamp.net\/","name":"ExcelChamp","description":"Solving Everyday Problems With Excel","publisher":{"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.excelchamp.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba","name":"Vinai Prakash","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/image\/","url":"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash.png?fit=487%2C720&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash.png?fit=487%2C720&ssl=1","width":487,"height":720,"caption":"Vinai Prakash"},"logo":{"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/image\/"},"description":"Vinai Prakash is the founder and master trainer of ExcelChamp.Net. Vinai has over 30 years of experience in using Excel, and is a Data Warehousing &amp; Business Intelligence Professional. Vinai has coached and trained over 30,000 professionals in using Excel, Power BI, Python, SQL, and regularly runs Excel Data Analysis, Excel Dashboard MasterClass, Excel for Beginners, Advanced Excel MasterClass online and all over the world. Vinai's Videos on YouTube channel and his blog articles and newsletters are read by thousands of subscribers all over the world. Vinai lives in Singapore with his wife and 2 kids.","sameAs":["https:\/\/ExcelChamp.Net","https:\/\/www.facebook.com\/profile.php?id=100079767634794","https:\/\/www.linkedin.com\/in\/vinaiprakash\/","https:\/\/www.youtube.com\/user\/ExcelChamp"],"url":"https:\/\/www.excelchamp.net\/author\/ppfdd\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2023\/11\/Slide26.jpg?fit=1280%2C720&ssl=1","_links":{"self":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts\/116"}],"collection":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/comments?post=116"}],"version-history":[{"count":10,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts\/116\/revisions"}],"predecessor-version":[{"id":2768,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts\/116\/revisions\/2768"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/media\/2193"}],"wp:attachment":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/media?parent=116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/categories?post=116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/tags?post=116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}