How to easily compare two Excel Columns

Anurag Bansal

Anurag Bansal is the Founder & CEO of Techacker. He is an entrepreneur, technology enthusiasts and social media strategist helping startups and fellow entrepreneurs achieve success by leveraging the power of internet, social media and mobile web. Catch him on Twitter (@techacker), Facebook and Google+.

You may also like...

2 Responses

  1. fete says:

    Good ! Thanks for the code

    • Santosh Visal says:

      Set R1 = Range(S1.Cells(1, 1), S1.Cells.SpecialCells(xlCellTypeLastCell))
      Set R2 = Range(S2.Cells(1, 1), S2.Cells.SpecialCells(xlCellTypeLastCell))
      S3.Cells(1, 1).Formula = “=” & R1.Address(, , , True) & “=” & R2.Address(, , , True)
      bComp = S3.Cells(1, 1)