Hi,

I'm fairly new to Excel, not really used it too much. I was wondering if there's a way to automatically compare 2 workbooks, so that Excel reads back to you the differences between the 2. For example, a row on the first book might read:

1 3 5 7 9

And the same row on the second reads:

1 3 4 8 10

So, Excel would read to me (Assuming 0 is no change)

0 0 -1 +1 +1

Something along those lines? I don't even know where to begin looking for answers!

Many thanks in advance.