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!
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!
