Matching the values in two columns A and B and to see if there are common values in both the columns

Asadmir27 · #1 12-12-2016, 11:01 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel / Mail Merge - Return Column Headers for All and Any Columns with Values	eduams	Mail Merge	1	09-26-2016 07:02 PM
sum values in columns	pero978	Excel	3	01-30-2016 07:49 AM
Formula/function to return column names for matching values	GiJoe81	Excel	1	06-27-2015 12:13 AM
Hide rows in multiple columns based on zero values	Deane	Excel Programming	19	06-23-2015 11:24 PM
Copying and pasting values with unequal data columns	grexcelman	Excel Programming	5	12-05-2014 11:36 AM