In our formula, A1 is the first cell of the first column that we want to use for comparison. In the first empty cell, in our example this is Cell C1, write the following formula:.Compare data between 2 columns with a visual wizardĬompare 2 columns to find duplicates using Excel formulas Variant A: both columns are on the same list.Remove duplicates from the first column.Variant B: two columns are on different worksheets (workbooks).Variant A: both columns are on the same list.Compare 2 columns to find duplicates using formulas.Furthermore, it can only remove dupes, no other choice such as highlighting or coloring is available, alas :-(.įurther on, I am going to describe 2 possible ways of comparing two Excel columns that let you find and remove duplicate entries: The built-in Remove Duplicate tool available in Excel 2016, Excel 20 cannot handle this scenario because it cannot compare data between 2 columns. Variant B: Two columns are located on different sheets: Column A in Sheet2 and Column A in Sheet3 Variant A: Both columns are located on one sheet, in a single table: Column A and Column B As you understand, this is bogus data just for a quick example in real worksheets you usually have thousands and tens of thousands of entries. Say, you have 2 columns with people names - 5 names in column A and 3 names in column B, and you want to compare data between these two columns to find duplicates. These two columns may be located in one table, contiguously or non-contiguously, or they may reside in 2 different worksheets or even workbooks. Now that you have lots of workbooks with a pool of data, or maybe just one huge table, you may want to compare 2 columns for duplicates and then do something with found entries, for example delete duplicate rows, color dupes or clear the contents of duplicated cells. Okay, the countdown is started!Įxcel is a very powerful and really cool application for creating and processing large arrays of data. It will take you about 10 minutes to read this article and in the next 5 minutes (or even faster if you choose the 2nd solution described in the article) you will easily compare two Excel columns for duplicates and remove or highlight the found dupes.
0 kommentar(er)
