how to remove duplicate numbers in excel 2007

In an adjacent column, use the following formula:ĭrag this down for all the rows.

Have a look:įinding duplicate rows is a bit more complex than finding duplicate cells. This will highlight all the cells that have duplicates value in the selected data set.įinding and Highlighting Duplicate Rows in Excelįinding duplicate data and finding duplicate rows of data are 2 different things.In the Duplicate Values dialog box, select Duplicate in the drop down on the left, and specify the format in which you want to highlight the duplicate values.If you have data that spans multiple columns and you need to look for duplicates in it, the process is exactly the same as above. Finding and Highlight Duplicates in Multiple Columns in Excel A good idea would be to use the TRIM function to clean your data. For example, “John” and “John ” are considered different as the latter has an extra space character in it. Quick Tip: Remember to check for leading or trailing spaces. This will highlight all the values that have duplicates.You can choose from the ready-made format options (in the drop down on the right), or specify your own format. Go to Home –> Conditional Formatting –> Highlight Cell Rules –> Duplicate Values.Select the data in which you want to highlight the duplicates.Finding and Highlight Duplicates in a Single Column in ExcelĬonditional Formatting makes it simple to highlight duplicates in Excel. You can have it in a single column or multiple columns. There may also be a duplication of an entire row. Remove Duplicates from Multiple Columns.ĭuplicates in Excel can come in many forms.Remove Duplicates from a Single Column.Find and Highlight Duplicates in Multiple Columns.Find and Highlight Duplicates in a Single Column.FIND and HIGHLIGHT Duplicates in Excel.

How to remove duplicate numbers in excel 2007