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)
