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!
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,517
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
office 2013 contains INQUIRE which should allow workbook comparisons
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,108,969
Messages
5,525,960
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top