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

Asadmir27 · #5 12-13-2016, 02:58 AM

Quote:

Originally Posted by xor

I forgot to mention that the formula is an array formula meaning that instead of just pressing Enter when finishing the formula you must hold down Ctrl and Shift before pressing Enter: If you do it correct Excel will put braces {} around the formula. Don't try to enter
these {} manually.

Thanks. I knew it must be an array formula as we are comparing whole columns. If you please explain the formula briefly step by step in the worksheet with actual formula and send me attachment, it would be much easier to understand. Thanks again.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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