This is probably incredibly basic and has a simple answer - at least I hope it does. I am using Excel 2007.
I have 2 worksheets run from 2 different systems. The systems are supposed to have the exact same information, but unfortunately Sheet A has 1350 results and Sheet B has 1365 results. I am trying to identify which items are in Sheet B that are not in Sheet A. How would I do this? Similarly, I also want to know which items are matched/paired in both sheets.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!