Sunny Shaikh

Sunny Shaikh

  • NA
  • 48
  • 23.9k

Compare Entire rows in two sheets in - Excel

Oct 27 2014 8:13 AM
I have two sheet with same data and I want to compare entire row in two sheets.

On Sheet1 (old data)
Col A       | Col B
1001 | My Val 1
2001 | My Val 2
3001 | My Val 3

On Sheet2 (new data)
Col A       | Col B                 | Col C
2001 | My Val 2             | True
3001 | My new Val 3 | False
1001 | My new Val 1 | False