- #COMPARE TWO COLUMNS IN EXCEL AND REMOVE DUPLICATES HOW TO#
- #COMPARE TWO COLUMNS IN EXCEL AND REMOVE DUPLICATES CODE#
1.Įnter the following code in a module sheet: Sub Find_Matches() Dim CompareRange As Variant, x As Variant, y As Variant ' Set CompareRange equal to the range to which you will ' compare the selection. In Excel, there is no built-in function can quickly merge sheets and remove duplicates, you just can copy and paste the sheet contents one by one then apply Remove Duplicates function to remove the duplicates. Select the column (s) from the first table and the matching column (s) from the second worksheet to compare them and check for duplicate or unique data.
Select the columns for comparison This step displays a list of columns in both Excel spreadsheets.
#COMPARE TWO COLUMNS IN EXCEL AND REMOVE DUPLICATES HOW TO#
How to compare two Excel sheets and remove duplicates That doesn't deal with the need to delete anything - just shows you which entries appear in both lists. Duplicates will be marked by echoing the contents of column B in Column C. In column C use this formula (based on your example, adjust cell ranges to match reality) =IF(COUNTIF(A$1:A$5,B1)>0,B1,"") extend that down to match entries in column B. In this case, we will not be doing a row by row comparison. Note that this is different than what we have seen when comparing each row. Method 1: Use a worksheet formula Start Excel.Ĭompare Two Columns and Highlight Matches If you want to compare two columns and highlight matching data, you can use the duplicate functionality in conditional formatting. You can use the following methods to compare data in two Microsoft Excel worksheet columns and find duplicate entries. Now all the matches of two compared columns are deleted. Click Data > Filter again to remove the filter, and then remove the formulas if you do not need it any more. Now only the duplicates are visible, select them in the Name1 column, and press Delete key in the keyboard to delete them. Actually, there are some other ways to solve it as well. To compare two columns and remove the duplicate values, we have already posted a tutorial about how to solve this problem by ‘Conditional Formatting’ feature ‘Remove Duplicate’ rule. How to compare two columns in Excel and delete duplicates
0 kommentar(er)
