excel remove duplicate rows based on column

Excel remove duplicate rows based on column how to#

Highlight the columns with the duplicate values. The only difference is the “Remove Duplicates” dialog box-you’ll need to confirm the columns you wish to remove duplicates from. Removing duplicates from multiple columns in Excel is the exact same process as removing duplicate values from a single column.

Excel remove duplicate rows based on column how to#

Related: How To Calculate Mean in Excel and Why It's Important Remove duplicate values from multiple columns in Excel The duplicate values in the column will be removed, with Excel providing a summary, e.g., 7 duplicate values found and removed 2 unique values remain. If your cell range does not include headers, leave the “My data has headers” box in the upper-right unchecked. By default, each column your cell range includes will be ticked off with a check in a box. In the Remove Duplicates box that appears, confirm the range you wish to remove the duplicate values from. Expand the cell range by dragging your cursor to the last cell and release the button. To do so, click on an Excel cell and hold down the left button of your mouse. Highlight the cells you want to remove a duplicate value or duplicates from. To remove duplicate values from a cell range, start by selecting the range with your mouse: Related: How to Sort Data in Excel (With Step-by-Step Instructions) Remove duplicate values from a range of cells in Excel Note: If your column is next to another column, Excel will first return a warning asking if you want to “Expand the selection” or “Continue with the current selection.” To remove duplicates from a single column, select “Continue with the current selection,” then “Remove duplicates.” The duplicate values in the column will be removed, with Excel providing a summary, e.g., 2 duplicate values found and removed 6 unique values remain. Make sure to check the box in the upper right as well as “My data has headers” if your dataset has a header this will prevent it from being included in the removal. In the Remove Duplicates box that appears, confirm the column you wish to remove the duplicate values from. This will open up the Data ribbon in Excel.įrom the ribbon, go the Data Tools group and click on Remove Duplicates (this is the icon with three tiers and an “x”). Do so by clicking on the column’s letter (e.g., for column A, click on A)Ĭlick on Data from the top menu. Highlight the column with the duplicate value. To remove a duplicate value in a specific column in Excel, start by selecting the column: The following sections include step-by-step instructions for how to remove duplicate values from a single column, from a range of cells and from multiple columns in an Excel spreadsheet: Remove duplicate values from a single column in Excel There are several ways you can remove duplicate values from Excel depending on your goal.