{"id":8396,"date":"2023-09-23T16:25:38","date_gmt":"2023-09-23T16:25:38","guid":{"rendered":"https:\/\/businessyield.com\/tech\/?p=8396"},"modified":"2023-09-23T16:25:59","modified_gmt":"2023-09-23T16:25:59","slug":"how-to-find-duplicates-in-excel","status":"publish","type":"post","link":"https:\/\/businessyield.com\/tech\/how-to\/how-to-find-duplicates-in-excel\/","title":{"rendered":"HOW TO FIND DUPLICATES IN EXCEL: Step-By-Step Guide","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Almost every organization and business uses Excel spreadsheets to store data about employees, clients, and projects. This is because Excel offers versatile tools and features for data storage, manipulation, and analysis. As much as acquiring skills and certification courses in Excel and Microsoft gives you a competitive edge over others, as the organization expands, the data expands as well. To help you, Excel provides many features to find, highlight, and identify duplicates in Excel columns without deleting them.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-overview\"><span id=\"overview\">Overview<\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Microsoft Excel is a popular piece of office software that lets people make spreadsheets for a wide range of purposes. Excel skills are often needed for jobs, and getting better at Excel could be a good way to make yourself more marketable in the job market. One way to get better at Excel is to figure out how to find copies in Excel files. In this piece, we explain why it&#8217;s important to find duplicates, show you how to find, and identify them in Excel, and give you tips to help you find duplicates in your projects.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-tips-for-finding-duplicates-in-excel\"><span id=\"tips-for-finding-duplicates-in-excel\">Tips For Finding Duplicates in Excel<\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Here are some tips that can help you find copies more easily in your Excel projects:<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-1-master-formulas-nbsp\"><span id=\"1-master-formulas\">#1. Master formulas&nbsp;<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Formulas may be difficult at first, but they make specialized jobs easier. Check out Microsoft&#8217;s support page and Excel blogs.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-2-always-check-nbsp\"><span id=\"2-always-check\">#2. Always check&nbsp;<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">In smaller collections, duplicates are easy to find. When working on a project, check spreadsheets for copies often.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-3-learn-more-about-excel\"><span id=\"3-learn-more-about-excel\">#3. Learn More About Excel<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">if you frequently use it at work. To identify duplication and other duties faster, watch video tutorials and test different functions.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-how-to-find-duplicates-in-excel\"><span id=\"how-to-find-duplicates-in-excel\">How to Find Duplicates in Excel<\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Spreadsheets in Excel are a handy way to organize and look at data. Even though duplicate values are sometimes necessary for a data set, they can make the information less clear and harder to evaluate correctly. Due to human mistakes, Excel sheets can also have duplicate values, which can make the data wrong. To stop this from happening, it&#8217;s often helpful to find copies so you can decide whether or not to get rid of them.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-how-to-find-duplicates-in-excel-step-by-step-guide\"><span id=\"how-to-find-duplicates-in-excel-step-by-step-guide\">How to Find Duplicates in Excel: Step-by-step Guide<\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">It&#8217;s normal for data to come from more than one place, for multiple people to enter records, or for more than one transaction to have the same information. Because of this, you will need to find and change copies. Hence, Excel gives you different ways to do this based on the data you have and the results you want. To help you, here are several methods that you can use to find, count, and filter duplicates in Microsoft Excel<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-1-how-to-find-duplicates-in-excel-using-the-conditional-formatting-method\"><span id=\"1-how-to-find-duplicates-in-excel-using-the-conditional-formatting-method\">#1. How to Find Duplicates in Excel: Using the Conditional Formatting Method<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">You can use this method to locate cells with duplicate information in Excel:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Open Excel.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click the upper left &#8220;File&#8221; option.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select &#8220;Open&#8221; from the drop-down menu.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the dialogue box, pick your file.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Finish by clicking &#8220;Open&#8221; to close the window and view your paper.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Choose the cell range to check for duplicates.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Highlight cells by right-clicking and dragging to select the full range.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the upper left corner of the screen, click &#8220;Home&#8221;.<\/li>\n\n\n\n<li>Use the menu to select &#8220;Conditional Formatting.&#8221;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>When the drop-down menu opens, hover over &#8220;Highlight Cell Rules&#8221; at the top.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>On the second menu, click &#8220;Duplicate Values&#8221; at the bottom.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the dialogue box, click the right-down arrow and select a formatting style to format duplicate values.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>When done, click &#8220;OK&#8221; to exit the window and apply the changes.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Your chosen color will highlight duplicate data in Excel.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-2-how-to-find-duplicates-in-excel-using-the-triplicate-values\"><span id=\"2-how-to-find-duplicates-in-excel-using-the-triplicate-values\">#2. How to Find Duplicates in Excel: Using the triplicate values<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">If you want to find only triplicate values, you can use the following steps:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Open Microsoft Excel.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click &#8220;File&#8221; in the top left corner.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select &#8220;Open.&#8221; from the drop-down option.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Find your document in the dialogue window and click it.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click &#8220;Open&#8221; to exit the dialogue box and view your spreadsheet after selecting the file.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Selecting the region you&#8217;re working on and hitting the &#8220;Home&#8221; button in the upper left corner will delete any conditional formatting.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click &#8220;Conditional Formatting&#8221; next.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the drop-down menu, click &#8220;Clear Rules&#8221; at the bottom.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The second menu&#8217;s first choice is &#8220;Clear Rules from Selected Cells.&#8221;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Leave the cells highlighted and click &#8220;Conditional Formatting&#8221; again after clearing the settings.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click &#8220;New Rule&#8221; at the bottom of the drop-down menu.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the dialogue box, find &#8220;Select a Rule Type&#8221; and&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click &#8220;Use a formula to format cells.&#8221;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>There will be a text box under &#8220;Format values where this formula is true.&#8221;<\/li>\n\n\n\n<li>Enter the formula: =COUNTIF($A$1:$C$10,A1)=3 in the text box.<\/li>\n\n\n\n<li>After finishing, click &#8220;OK&#8221; to close the dialogue box.<\/li>\n\n\n\n<li>Excel will now show duplicate numbers in the selected area.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-3-how-to-find-duplicates-in-excel-using-the-countif-method\"><span id=\"3-how-to-find-duplicates-in-excel-using-the-countif-method\">#3. How to Find Duplicates in Excel: Using the COUNTIF Method<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">You can use the following steps to find duplicates in your documents using a COUNTIF formula:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Like above, open Excel and your document.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Pick the cell next to the first cell in the range to check for duplicates. We&#8217;re using A2, so we chose B2.<\/li>\n\n\n\n<li>In the formula bar above the spreadsheet, enter: =COUNTIF(A: A, A2)&gt;1.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>From the formula straight into the cell.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A2 is the initial cell, however, you can write another cell in the formula.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the highlighted cell, click the little box in the lower right corner.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Dragging highlights other cells to check.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Duplicates appear as &#8220;True&#8221; in Excel, while unique values appear as &#8220;False&#8221;.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>To change Excel&#8217;s &#8220;True&#8221; or &#8220;False,&#8221; adjust the calculation.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>To display &#8220;Duplicate&#8221; and &#8220;Unique,&#8221; use the following formula in the blank cell located next to your first cell: =IF&nbsp; (COUNTIF (A: A, A2)&gt;1, &#8220;Duplicate&#8221;, Unique.&#8221;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Next, drag to check all column cells.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Formulas that display &#8220;Duplicate&#8221; next to duplicate values and blank next to unique values are also available:<\/li>\n\n\n\n<li>=IF(COUNTIF (A:A,A2)|&#8221;Duplicate&#8221;, &#8220;&#8221;)<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Finally, dragging selects all column cells and checks for duplicates.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-find-duplicates-in-the-excel-column\"><span id=\"find-duplicates-in-the-excel-column\">Find Duplicates in the Excel Column<\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">When a value occurs in a column more than once, it is called a duplicate value. Microsoft Excel is a common tool in business analysis, but it can be challenging to spot and remove duplicate data. In Excel, it is common practice to clean up massive datasets by deleting duplicates. This is because Duplicate data can appear in a spreadsheet if many users have access to the same document or if two or more tables are merged into one.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Consequently, the information is useless. This is so because duplication becomes more common as data sets grow larger. Problems may arise if they are not identified and addressed in a timely manner. Also, Excel&#8217;s built-in functions and basic formulas are straightforward to use to find and highlight duplicates. The following guide shows how to find several values in a column, including illustrations and the correct format.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-find-duplicates-in-the-excel-column-step-by-step-guide\"><span id=\"find-duplicates-in-the-excel-column-step-by-step-guide\">Find Duplicates in the Excel Column: Step-by-step Guide<\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Finding duplicates in a single Excel column or across numerous columns is harder than filtering. With Excel&#8217;s conditional formatting, you may easily detect duplicates in a single column, but there&#8217;s no reason to eliminate them. To find duplicates in Excel columns quickly and efficiently, follow the instructions below.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-step-1-highlight-the-column-with-the-duplicate-values\"><span id=\"step-1-highlight-the-column-with-the-duplicate-values\">Step 1: Highlight the Column With the Duplicate Values.<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">In Microsoft Excel, the first step to finding duplicates is to point out the column with the duplicate numbers. To do this, click and drag your mouse over the column header to select the full column. When it is selected, a blue edge will show up around the column.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-step-2-open-up-the-conditional-formatting-tool\"><span id=\"step-2-open-up-the-conditional-formatting-tool\">Step 2: Open up the Conditional Formatting Tool<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">The next thing to do is to open the tool for conditional formatting. To open the tool, click on the Home tab and then on Conditional Formatting. When you open the Conditional Formatting tool, choose &#8220;Highlight Cell Rules&#8221; and then &#8220;Duplicate Values.&#8221;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-step-3-select-the-options-for-duplicate-value-nbsp\"><span id=\"step-3-select-the-options-for-duplicate-value\">Step 3: Select the Options for Duplicate Value&nbsp;<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">When you choose the &#8220;Duplicate Values&#8221; choice, a window will pop up where you can choose different duplicate value options. These choices include the type of formatting to use on the duplicate values and the range of cells to look for duplicates.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-step-4-review-the-duplicate-values-nbsp\"><span id=\"step-4-review-the-duplicate-values\">Step 4: Review the Duplicate Values&nbsp;<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Once the duplicate numbers have been found, you can look at each one to see if it should be taken out. To get rid of the duplicate values, pick the cell that has the value and press the delete key.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-step-5-clear-conditional-formatting-nbsp\"><span id=\"step-5-clear-conditional-formatting\">Step 5: Clear Conditional Formatting&nbsp;<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Once you have gone through all of the duplicate numbers and deleted the ones you don&#8217;t want, you can turn off the conditional formatting. To do this, select the Home tab and then click Conditional Formatting. Choose &#8220;Clear Rules,&#8221; then choose &#8220;Clear Rules from Selected Cells.&#8221; This will delete the conditional formatting from the chosen cells.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-how-to-identify-duplicates-in-excel-without-deleting\"><span id=\"how-to-identify-duplicates-in-excel-without-deleting\">How to Identify Duplicates in Excel Without Deleting<\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">When dealing with a lot of data, we often have problems with duplicate entries in Excel. The most common ways to find duplicates in Excel are the COUNTIF tool and Conditional Formatting. Aside from these two, we will look at several other ways to Find Duplicates in Excel Without Deleting Them.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-how-to-identify-duplicates-in-excel-without-deleting-step-by-step-guide\"><span id=\"how-to-identify-duplicates-in-excel-without-deleting-step-by-step-guide\">How to Identify Duplicates in Excel Without Deleting: Step-by-step Guide<\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">We will see how Conditional Formatting and different functions like COUNTIF, IF, etc. can be used to find duplicates based on our tastes without deleting them.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-1-how-to-identify-duplicates-in-excel-without-deleting-by-conditional-formatting\"><span id=\"1-how-to-identify-duplicates-in-excel-without-deleting-by-conditional-formatting\">#1. How to Identify Duplicates in Excel Without Deleting: by Conditional Formatting<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Conditional formatting helps you identify the presence of duplicates in the table and eliminate them, which can be done by following these steps:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>First, specify the range of cells you want to look for duplicates in.&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Next, click on the &#8220;Conditional Formatting&#8221; button on the &#8220;Home&#8221; tab of the Ribbon.&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select &#8220;Highlight Cell Rules&#8221; from the drop-down menu and then &#8220;Duplicate Values&#8221; from the next menu.&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Lastly, choose the format you want to apply to the duplicate numbers and click &#8220;OK.&#8221;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Once you apply the conditional formatting to your data set, any duplicate numbers will be highlighted in the color(s) you chose.&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You can then take steps to get rid of the duplicates, if necessary.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-2-how-to-identify-duplicates-in-excel-without-deleting-by-formulas\"><span id=\"2-how-to-identify-duplicates-in-excel-without-deleting-by-formulas\">#2. How to Identify Duplicates in Excel Without Deleting: by formulas<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Here are some formulas that can be used to find the numbers in a list that are repeated without deleting them.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select a blank cell next to the list of numbers you want to find duplicates of,&nbsp;<\/li>\n\n\n\n<li>Then enter the formula =IF(COUNTIF($A$1:$A$14, A2)&gt;1, DUPLICATE&#8221;,&#8221;), and&nbsp;<\/li>\n\n\n\n<li>Finally,&nbsp; drag the fill handle down to the cell where this formula needs to be applied.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-3-how-to-identify-duplicates-in-excel-without-deleting-by-countif\"><span id=\"3-how-to-identify-duplicates-in-excel-without-deleting-by-countif\">#3. How to Identify Duplicates in Excel Without Deleting: by COUNTIF<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">The easiest way to find duplicates without deleting them is with the COUNTIF function. To do this, follow these steps:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>First, type the code that appears below into cell F5.<\/li>\n\n\n\n<li>Next, Press the ENTER key.<\/li>\n\n\n\n<li>The last step is to move down to AutoFill for the rest of the series.<\/li>\n\n\n\n<li>COUNTIF functions return TRUE if there are duplicates in a given range, and FALSE if there are no duplicates.<\/li>\n\n\n\n<li>Then, choose the whole set of data and press CTRL+SHIFT+L.<\/li>\n\n\n\n<li>Last, search the dataset for numbers that are TRUE.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-how-do-i-find-duplicates-in-two-excel\"><span id=\"how-do-i-find-duplicates-in-two-excel\">How Do I Find Duplicates in Two Excel?<\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">They are,<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>VLOOKUP, COUNTIF, or EXACT functions<\/li>\n\n\n\n<li>Conditional formatting.<\/li>\n\n\n\n<li>Power Query.<\/li>\n\n\n\n<li>External tools and add-ins.<\/li>\n\n\n\n<li>Visual checks for duplicates.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-how-do-i-select-only-duplicates-in-excel-nbsp\"><span id=\"how-do-i-select-only-duplicates-in-excel\">How Do I Select Only Duplicates in Excel?&nbsp;<\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Selected cells in a range, table, or pivot table report. Click Conditional Formatting, then New Rule, in the Home tab&#8217;s Styles group. Choose Classic in Style, then Format only top or bottom ranked values in Format only unique or duplicate values.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-is-the-fastest-way-to-count-duplicates-in-excel\"><span id=\"what-is-the-fastest-way-to-count-duplicates-in-excel\">What is the Fastest Way to Count Duplicates in Excel?<\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">By using the COUNTIF function.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-is-the-best-formula-to-find-duplicates-in-excel\"><span id=\"what-is-the-best-formula-to-find-duplicates-in-excel\">What is the Best Formula to Find Duplicates in Excel?<\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">=IF(COUNTIF($A$2:$A$7, A2)&gt;1,\u201d Duplicate\u201d,\u201d Unique\u201d).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-how-do-i-find-duplicates-in-a-table\"><span id=\"how-do-i-find-duplicates-in-a-table\">How Do I Find Duplicates in a Table?<\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">By using the GROUP BY and HAVING clauses<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-in-a-nutshell\"><span id=\"in-a-nutshell\">In a Nutshell<\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">I am convinced you now have a good idea of how to find duplicate numbers in columns in Excel. Use whichever method you feel most comfortable with. Also, if you have any questions or doubts about this topic, feel free to leave a comment here.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-references\"><span id=\"references\">References<\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.academyoflearning.com\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">.academyoflearning<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.indeed.com\/career-advice\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">indeed<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.simplilearn.com\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">simplilearn<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/softkeys.uk\/blogs\/b\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">softkeys.<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.extendoffice.com\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">.extendoffice<\/a><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-related-posts\"><span id=\"related-posts\">Related Posts<\/span><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><a href=\"https:\/\/businessyield.com\/tech\/how-to\/how-to-add-time\/\" target=\"_blank\" rel=\"noreferrer noopener\">HOW TO ADD TIME IN EXCEL: Fast &amp;amp; Easy Guide<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/businessyield.com\/tech\/how-to\/how-to-split-cells-in-excel\/\" target=\"_blank\" rel=\"noreferrer noopener\">HOW TO SPLIT CELLS IN EXCEL: Detailed Guide<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/businessyield.com\/tech\/reviews\/optimal-workshop\/\">OPTIMAL WORKSHOP: Features, Review, Pricing &amp; More<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/businessyield.com\/tech\/how-to\/how-to-highlight-duplicates-in-excel\/\" target=\"_blank\" rel=\"noreferrer noopener\">HOW TO HIGHLIGHT DUPLICATES IN EXCEL: Complete Guide<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/businessyield.com\/tech\/how-to\/how-to-unhide-sheets-in-excel\/\" target=\"_blank\" rel=\"noreferrer noopener\">HOW TO UNHIDE SHEETS IN EXCEL: Step-By-Step Guide<\/a><\/li>\n<\/ol>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"Almost every organization and business uses Excel spreadsheets to store data about employees, clients, and projects. This is&hellip;\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":286,"featured_media":8406,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[11],"tags":[],"class_list":["post-8396","post","type-post","status-publish","format-standard","has-post-thumbnail","category-how-to"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>HOW TO FIND DUPLICATES IN EXCEL: Step-By-Step Guide<\/title>\n<meta name=\"description\" content=\"Microsoft Excel is a popular piece of office software that lets people make spreadsheets for a wide range of purposes. To help you, Excel provides many features to find, highlight, and identify duplicates in Excel column without deleting them.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/businessyield.com\/tech\/how-to\/how-to-find-duplicates-in-excel\/\" \/>\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: Step-By-Step Guide\" \/>\n<meta property=\"og:description\" content=\"Microsoft Excel is a popular piece of office software that lets people make spreadsheets for a wide range of purposes. To help you, Excel provides many features to find, highlight, and identify duplicates in Excel column without deleting them.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/businessyield.com\/tech\/how-to\/how-to-find-duplicates-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Business Yield Technology\" \/>\n<meta property=\"article:published_time\" content=\"2023-09-23T16:25:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-09-23T16:25:59+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/businessyield.com\/tech\/wp-content\/uploads\/sites\/2\/2023\/09\/Untitled-design-38.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"250\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Chinecherem Onuorah\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Chinecherem Onuorah\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-find-duplicates-in-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-find-duplicates-in-excel\\\/\"},\"author\":{\"name\":\"Chinecherem Onuorah\",\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/#\\\/schema\\\/person\\\/59cd27f29aeeb00675e27d3db92755f1\"},\"headline\":\"HOW TO FIND DUPLICATES IN EXCEL: Step-By-Step Guide\",\"datePublished\":\"2023-09-23T16:25:38+00:00\",\"dateModified\":\"2023-09-23T16:25:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-find-duplicates-in-excel\\\/\"},\"wordCount\":2103,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-find-duplicates-in-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/businessyield.com\\\/tech\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/09\\\/Untitled-design-38.jpg?fit=500%2C250&ssl=1\",\"articleSection\":[\"How-to\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-find-duplicates-in-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-find-duplicates-in-excel\\\/\",\"url\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-find-duplicates-in-excel\\\/\",\"name\":\"HOW TO FIND DUPLICATES IN EXCEL: Step-By-Step Guide\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-find-duplicates-in-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-find-duplicates-in-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/businessyield.com\\\/tech\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/09\\\/Untitled-design-38.jpg?fit=500%2C250&ssl=1\",\"datePublished\":\"2023-09-23T16:25:38+00:00\",\"dateModified\":\"2023-09-23T16:25:59+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/#\\\/schema\\\/person\\\/59cd27f29aeeb00675e27d3db92755f1\"},\"description\":\"Microsoft Excel is a popular piece of office software that lets people make spreadsheets for a wide range of purposes. To help you, Excel provides many features to find, highlight, and identify duplicates in Excel column without deleting them.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-find-duplicates-in-excel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-find-duplicates-in-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-find-duplicates-in-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/businessyield.com\\\/tech\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/09\\\/Untitled-design-38.jpg?fit=500%2C250&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/businessyield.com\\\/tech\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/09\\\/Untitled-design-38.jpg?fit=500%2C250&ssl=1\",\"width\":500,\"height\":250,\"caption\":\"Image by rawpixel.com on freepik\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/how-to\\\/how-to-find-duplicates-in-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"HOW TO FIND DUPLICATES IN EXCEL: Step-By-Step Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/#website\",\"url\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/\",\"name\":\"Business Yield Technology\",\"description\":\"Best Tech Reviews, Apps, Phones, &amp; Gaming\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/#\\\/schema\\\/person\\\/59cd27f29aeeb00675e27d3db92755f1\",\"name\":\"Chinecherem Onuorah\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1b09cd1b748a80d7e00bb7711687b0a4daa460ffcee63ac720f8fabd37eac2d7?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1b09cd1b748a80d7e00bb7711687b0a4daa460ffcee63ac720f8fabd37eac2d7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1b09cd1b748a80d7e00bb7711687b0a4daa460ffcee63ac720f8fabd37eac2d7?s=96&d=mm&r=g\",\"caption\":\"Chinecherem Onuorah\"},\"description\":\"Onuora Favour is a content writer, editor, and lifelong learner with an insatiable desire to discover new things. She combines her bachelor's degree in business administration with her natural interest and expertise as a sales team lead and SEO expert to offer comprehensive articles that are informative for individuals and business owners.\",\"url\":\"https:\\\/\\\/businessyield.com\\\/tech\\\/author\\\/chinecherem\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"HOW TO FIND DUPLICATES IN EXCEL: Step-By-Step Guide","description":"Microsoft Excel is a popular piece of office software that lets people make spreadsheets for a wide range of purposes. To help you, Excel provides many features to find, highlight, and identify duplicates in Excel column without deleting them.","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:\/\/businessyield.com\/tech\/how-to\/how-to-find-duplicates-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"HOW TO FIND DUPLICATES IN EXCEL: Step-By-Step Guide","og_description":"Microsoft Excel is a popular piece of office software that lets people make spreadsheets for a wide range of purposes. To help you, Excel provides many features to find, highlight, and identify duplicates in Excel column without deleting them.","og_url":"https:\/\/businessyield.com\/tech\/how-to\/how-to-find-duplicates-in-excel\/","og_site_name":"Business Yield Technology","article_published_time":"2023-09-23T16:25:38+00:00","article_modified_time":"2023-09-23T16:25:59+00:00","og_image":[{"width":500,"height":250,"url":"http:\/\/businessyield.com\/tech\/wp-content\/uploads\/sites\/2\/2023\/09\/Untitled-design-38.jpg","type":"image\/jpeg"}],"author":"Chinecherem Onuorah","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Chinecherem Onuorah","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/businessyield.com\/tech\/how-to\/how-to-find-duplicates-in-excel\/#article","isPartOf":{"@id":"https:\/\/businessyield.com\/tech\/how-to\/how-to-find-duplicates-in-excel\/"},"author":{"name":"Chinecherem Onuorah","@id":"https:\/\/businessyield.com\/tech\/#\/schema\/person\/59cd27f29aeeb00675e27d3db92755f1"},"headline":"HOW TO FIND DUPLICATES IN EXCEL: Step-By-Step Guide","datePublished":"2023-09-23T16:25:38+00:00","dateModified":"2023-09-23T16:25:59+00:00","mainEntityOfPage":{"@id":"https:\/\/businessyield.com\/tech\/how-to\/how-to-find-duplicates-in-excel\/"},"wordCount":2103,"commentCount":0,"image":{"@id":"https:\/\/businessyield.com\/tech\/how-to\/how-to-find-duplicates-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/businessyield.com\/tech\/wp-content\/uploads\/sites\/2\/2023\/09\/Untitled-design-38.jpg?fit=500%2C250&ssl=1","articleSection":["How-to"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/businessyield.com\/tech\/how-to\/how-to-find-duplicates-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/businessyield.com\/tech\/how-to\/how-to-find-duplicates-in-excel\/","url":"https:\/\/businessyield.com\/tech\/how-to\/how-to-find-duplicates-in-excel\/","name":"HOW TO FIND DUPLICATES IN EXCEL: Step-By-Step Guide","isPartOf":{"@id":"https:\/\/businessyield.com\/tech\/#website"},"primaryImageOfPage":{"@id":"https:\/\/businessyield.com\/tech\/how-to\/how-to-find-duplicates-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/businessyield.com\/tech\/how-to\/how-to-find-duplicates-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/businessyield.com\/tech\/wp-content\/uploads\/sites\/2\/2023\/09\/Untitled-design-38.jpg?fit=500%2C250&ssl=1","datePublished":"2023-09-23T16:25:38+00:00","dateModified":"2023-09-23T16:25:59+00:00","author":{"@id":"https:\/\/businessyield.com\/tech\/#\/schema\/person\/59cd27f29aeeb00675e27d3db92755f1"},"description":"Microsoft Excel is a popular piece of office software that lets people make spreadsheets for a wide range of purposes. To help you, Excel provides many features to find, highlight, and identify duplicates in Excel column without deleting them.","breadcrumb":{"@id":"https:\/\/businessyield.com\/tech\/how-to\/how-to-find-duplicates-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/businessyield.com\/tech\/how-to\/how-to-find-duplicates-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/businessyield.com\/tech\/how-to\/how-to-find-duplicates-in-excel\/#primaryimage","url":"https:\/\/i0.wp.com\/businessyield.com\/tech\/wp-content\/uploads\/sites\/2\/2023\/09\/Untitled-design-38.jpg?fit=500%2C250&ssl=1","contentUrl":"https:\/\/i0.wp.com\/businessyield.com\/tech\/wp-content\/uploads\/sites\/2\/2023\/09\/Untitled-design-38.jpg?fit=500%2C250&ssl=1","width":500,"height":250,"caption":"Image by rawpixel.com on freepik"},{"@type":"BreadcrumbList","@id":"https:\/\/businessyield.com\/tech\/how-to\/how-to-find-duplicates-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/businessyield.com\/tech\/"},{"@type":"ListItem","position":2,"name":"HOW TO FIND DUPLICATES IN EXCEL: Step-By-Step Guide"}]},{"@type":"WebSite","@id":"https:\/\/businessyield.com\/tech\/#website","url":"https:\/\/businessyield.com\/tech\/","name":"Business Yield Technology","description":"Best Tech Reviews, Apps, Phones, &amp; Gaming","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/businessyield.com\/tech\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/businessyield.com\/tech\/#\/schema\/person\/59cd27f29aeeb00675e27d3db92755f1","name":"Chinecherem Onuorah","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1b09cd1b748a80d7e00bb7711687b0a4daa460ffcee63ac720f8fabd37eac2d7?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1b09cd1b748a80d7e00bb7711687b0a4daa460ffcee63ac720f8fabd37eac2d7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1b09cd1b748a80d7e00bb7711687b0a4daa460ffcee63ac720f8fabd37eac2d7?s=96&d=mm&r=g","caption":"Chinecherem Onuorah"},"description":"Onuora Favour is a content writer, editor, and lifelong learner with an insatiable desire to discover new things. She combines her bachelor's degree in business administration with her natural interest and expertise as a sales team lead and SEO expert to offer comprehensive articles that are informative for individuals and business owners.","url":"https:\/\/businessyield.com\/tech\/author\/chinecherem\/"}]}},"modified_by":"Stanley Evergreen","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/businessyield.com\/tech\/wp-content\/uploads\/sites\/2\/2023\/09\/Untitled-design-38.jpg?fit=500%2C250&ssl=1","gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/businessyield.com\/tech\/wp-json\/wp\/v2\/posts\/8396","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/businessyield.com\/tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/businessyield.com\/tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/businessyield.com\/tech\/wp-json\/wp\/v2\/users\/286"}],"replies":[{"embeddable":true,"href":"https:\/\/businessyield.com\/tech\/wp-json\/wp\/v2\/comments?post=8396"}],"version-history":[{"count":5,"href":"https:\/\/businessyield.com\/tech\/wp-json\/wp\/v2\/posts\/8396\/revisions"}],"predecessor-version":[{"id":9763,"href":"https:\/\/businessyield.com\/tech\/wp-json\/wp\/v2\/posts\/8396\/revisions\/9763"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/businessyield.com\/tech\/wp-json\/wp\/v2\/media\/8406"}],"wp:attachment":[{"href":"https:\/\/businessyield.com\/tech\/wp-json\/wp\/v2\/media?parent=8396"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/businessyield.com\/tech\/wp-json\/wp\/v2\/categories?post=8396"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/businessyield.com\/tech\/wp-json\/wp\/v2\/tags?post=8396"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}