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, 02:58 AM
Asadmir27 Asadmir27 is offline Windows 7 64bit Office 2010 32bit
Banned
  
Join Date: Dec 2016
Posts: 5
Asadmir27 is on a distinguished road
Default
Quote:
Originally Posted by xor View Post
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.
Reply With Quote