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

		Microsoft Office Forums > Microsoft Excel > Excel
Matching the values in two columns A and B and to see if there are common values in both the columns

FAQ

Thread Tools

Display Modes

12-13-2016, 01:12 AM

xor

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

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,100

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.

Tags

common values, matching values, taking out common values

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:40 PM.