If your are using the Excel 2013, then you can have access to the mentioned Inquire Feature that allows you to compare two workbooks to identify the differences and find the unique values . This is very easy to use and very powerful tool which can save lot of time. First let's see how to activate this tool " Inquire " in Excel 2013. 1. Open the Excel sheet and Go to File >> Options 2. In Options, Select the " Add-Ins ", 3. In the Manage Drop down menu, select the " COM Add-Ins " and click on Go .. Button 4. And then check the Tick mark on " Inquire " Add-In and Click OK button. 5.Then, you can see a new tab "Inquire" placed on your excel ribbon at the top right side as shown. 6. Now, the actual comparison of two workbooks comes into picture. Let's begin the process by opening the two workbooks. Then go to Inquire tab of the ribbon and click the comparison tool. 7. Select the two
A Project Management Blog with free video tutorials and setups on various tools to enrich your knowledge in project management skills and much more softwares