View Single Post
 
Old 12-12-2016, 11:01 PM
Asadmir27 Asadmir27 is offline Windows 7 64bit Office 2010 32bit
Banned
 
Join Date: Dec 2016
Posts: 5
Asadmir27 is on a distinguished road
Default Matching the values in two columns A and B and to see if there are common values in both the columns

Attached is a worksheet named "Query". In this worksheet there are two columns "A" and "B" containing numbers in both columns. I want to compare values of one column completely with the values of other column and to see whether there are common values in both the columns. If there are any common values I want excel to show those values. For that, I need a formula. Any help would highly be appreciated....


Regards

Asad Iqbal Mir
Asadmir27@yahoo.com
Attached Files
File Type: xlsx Query.xlsx (8.7 KB, 10 views)
Reply With Quote