Comparing Workbooks For Unique Attributes

kealey1318

New Member
Joined
Feb 27, 2019
Messages
1
Hi all!

I just started a new job that will have a great deal of Excel work. I want to work 'smart' versus hard... I'd love any suggestions for my situation.

I have 2 Workbooks. In these 2 workbooks only 2 columns that match each other. I am to look for the outliers that don't match up in both of those columns. I did a pivot table to try to help and it did work out very nicely. Then, I have to take it a step further and if the data returned references only the master, I have to review the status. If anything but 'active' I have to remove.

Any suggestions? My eyeballs are exhausted! :)

This is my first post so I apologize if this is a repeat. I have been looking online because I have to do this monthly with 5 different divisions. Thank you in advance for reading!
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
office 2013 contains INQUIRE which should allow workbook comparisons
 
Last edited:
Upvote 0

Forum statistics

Threads
1,223,909
Messages
6,175,315
Members
452,634
Latest member
cpostell

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top