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)
