Hi Excel Ninja,
Thank you for your response. Would have suggestions for my 2nd concern? Writing a formula (or another way) to find the email address of a person that works at a certain company and fill the blank email spaces of the other people that work at the same company with the 1st email...
Hello,
I have 2 excel workbooks, one with more than 1500 people and the 2nd one with 300. I have the following information fields: 1st Name, Last Name, Email, Title, Company. I want to do 2 things:
1. Find all the duplicates in the 2 workbooks based on 1st Name, Last Name and Company AND do...