
❹ Now hit ‘New Rules’ from the Conditional Formatting drop-down list.Ī dialog box called New Formatting Rule will come along. To use highlight for finding duplicates follow these steps: It works great especially when you are in a hurry because you can look at the coloured cells quickly. Highlighting can make your work of sorting duplicate characters very easy. 🔗 5 Ways to Find Matching Values in Two Worksheets in Excel Alternative Way # 3: Use New Rule to Find Duplicates in Two Columns in Excel Such as ‘Match and Mismatch’, ‘Positive and Negative’, ‘Same and Unique’ etc. Instead of the words Duplicate and Different, you can use other words also. ❹ Now hold the Fill Handle and drag it to the end of the column ( C2-C12).
#Compare two columns in excel and remove duplicates how to#
🔗 How to Compare Rows in Excel for Duplicates (7 Ways) Alternative Way #1: Use the True/False Logical Formula to Find Duplicates in Two Columns in Excel 🔴 Method 7: Counts how many duplicates are in a datasheet. 🔴 Method 6: This technique will compare two columns in Excel and show the unique values as the difference between the columns. 🔴 Method 5: This technique will find out the duplicate values from the whole data set. 🔴 Method 4: Applicable where we need to compare two columns and return a result in the third column. 🔴 Method 3: If the texts (belonging in the same row) are duplicates, they will be highlighted. 🔴 Method 2: If the texts match the result will be DUPLICATE, if the texts don’t match the result will be DIFFERENT. 🔴 Method 1: The same texts will result in TRUE, the unique texts will result in FALSE. ❻ Then change the Values with the command according to your choice. ❺ In the Duplicate Values dialog box, check that Duplicate is selected inside the bar. ❹ Now go to Highlight Cells Rules > Duplicate Values.

❸ Then click on the Conditional Formatting drop-down (under Styles group).
