Thread: [Solved] Matching the values in two columns A and B and to see if there are common values in both the columns
View Single Post
 
Old 12-13-2016, 01:12 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
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.
Reply With Quote