Aspdotnet-Suresh

aspdotnet-suresh offers C#.net articles and tutorials,csharp dot net,asp.net articles and tutorials,VB.NET Articles,Gridview articles,code examples of asp.net 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

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

Jun 12, 2015
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

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


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 RSS subscribe by email Subscribe by Email

1 comments :

Top Essay Writing Service said...

Thanks for sharing this here. I have a confusion regarding how to compare two columns in excel. So you gave me the solution for the same and so this cleared my doubt.

Give your Valuable Comments

Note: Only a member of this blog may post a comment.

© 2015 Aspdotnet-Suresh.com. All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.