Need some help with Excel (we're running 2010).
I'm trying to compare two lists that should have the same items in them (auditing contractors, yay). I'm finding that the number of items in each list are different. Is there a way that I can have Excel look at the lists and tell me what is different in the lists? Basically, I want to be able to tell what is missing from one list or the other.
I've got the lists on separate tabs. I was thinking if I could get the items without a home shown on a third tab to be able to present to the folks who need to know.
There's about 1000 lines, so it's not something that I can quickly visualize.
Thanks, I'll hang up and listen.
I'm trying to compare two lists that should have the same items in them (auditing contractors, yay). I'm finding that the number of items in each list are different. Is there a way that I can have Excel look at the lists and tell me what is different in the lists? Basically, I want to be able to tell what is missing from one list or the other.
I've got the lists on separate tabs. I was thinking if I could get the items without a home shown on a third tab to be able to present to the folks who need to know.
There's about 1000 lines, so it's not something that I can quickly visualize.
Thanks, I'll hang up and listen.