Posted on 2014-10-30
I have a workbook in Excel 2007 that is pulling from SQL tables. I have worksheet A and Worksheet B with some values that are the same and some different.
I want to take and compare and find the difference from Worksheet B to Worksheet A. Example:
So now on worksheet C I would expect to see the difference of the following:
I want worksheet C to show what is on Worksheet B but not on Worksheet A. I am not sure what function to use to get the difference. I tried VLOOKUP but I want the difference of the two sheets. What is recommended to accomplish this for a function or formula?