Excel Compare Two Columns to Find Duplicate Values for Matches on Conditional Formatting

Introduction: 

Here I will explain how to compare two columns in excel to find duplicate values for matches on conditional formatting or excel conditional formatting to find duplicate values in columns or get / find duplicate values in columns in excel. By using excel conditional formatting formulas we can get duplicate values in excel columns.

Description:
  
In previous articles I explained shutdown system automatically in windows 7, keyboard event key codes and character codes, create desktop shortcut key to lock computer, configure dns server in windows 7. Now I will explain how to compare excel columns to find duplicate values for matches using conditional formatting.

I have one excel file with two username columns like as shown below

Now I want to get duplicate values by comparing both the columns. By using formulas concept in excel we can compare two columns data and display duplicate values for that we need to write formula “=IF(ISERROR(MATCH(A2,$C$2:$C$9,0)),"",A2)” like as shown in following image in column B to display duplicate values by comparing both columns

In above formula “A2” is the value which we need to compare and “$C$2:$C$9” is the range of values to compare in column C.

Now select “B2” cell and drag the file handle over cell 9 automatically it will highlight duplicate values like as shown below

I hope it helps you to get duplicate values from two columns……

If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS Subscribe by Email