I have two workbooks with similar data. I want to see what's the difference between them. One has columns that the other doesnt, and maybe vice versa, but I want to see if the entries are essentially the same.
How do I check which entries (store numbers) are in one sheet and not the other, and preferably vice versa as well? These would all be in col A, in both sheets. For some reason they're not all in increasing order.
I suppose one thing I could do would be to copy both columns into a third sheet and do a vlookup? I'd prefer something where I dont have to do that tho. However one thing, with vlookups, the tutorials I've read have said the data has to be in order. If its not, but in one of the parameters I choose exact match, does that also work?
How do I check which entries (store numbers) are in one sheet and not the other, and preferably vice versa as well? These would all be in col A, in both sheets. For some reason they're not all in increasing order.
I suppose one thing I could do would be to copy both columns into a third sheet and do a vlookup? I'd prefer something where I dont have to do that tho. However one thing, with vlookups, the tutorials I've read have said the data has to be in order. If its not, but in one of the parameters I choose exact match, does that also work?
