title: Compare two data sheets
body: <p>The issue I'm faced with is I have two sheets of data in Excel. They are a stocksheet list, listing items that have a variance from a stocktake. The items are randomly placed between both documents, so it is almost impossible to do a side-by-side view even if I were to order the columns (which I already have). For example it would be like this:</p>
  
  <p>Sheet 1:</p>
  
  <pre>A1 (Apple) (1)
  A2 (Carrot) (-3)
  A3 (Banana) (4)
  A4 (Chocolate (-7)</pre>
  
  <p>Whereas Sheet 2 may be:</p>
  
  <pre>A1 (Orange) (-2)
  A2 (Apple) (3)
  A3 (Muffin) (-8)
  A4 (Carrot) (3)</pre>
  
  <p>So as you can see, the same data may appear, and if it does I want to compare those two sets, to know the variance, i.e. Sheet 1 said -3 whereas sheet 2 said +1... I preferably would like to do this in a batch if possible, as there are over 800 cells to go through.</p>
  
  <p>Just so that you can see what I'm dealing with, here's links to pastebins of both sheets;</p>
  
  <p>Sheet 1: <a href="http://pastebin.com/6i7QKJ6N" rel="nofollow">http://pastebin.com/6i7QKJ6N</a>
  Sheet 2: <a href="http://pastebin.com/zjtC2U7q" rel="nofollow">http://pastebin.com/zjtC2U7q</a></p>
  
  <p>Is there anything anyone can think of that would be able to assist me, other than me going through this one by one which I am considering doing?</p>