• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Attention to all experts: How to compare workbooks, assign data to another cell?

F

fatou2010

New Member
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 one of the following : a. Highlight in yellow all the duplicates in the 2nd workbook with 300 people OR b. copy all the duplicates from both workbooks to another excel sheet.


2. In the 2nd workbook with 300 people, some of the people do not have an email. I want to fill out these blank emails by finding colleagues that work at the same company. For example, Dave doesn't have an email in the 2nd workbook and Dave works for IBM. His colleague at IBM, John, has an email address in the 1st workbook (john@ibm.com). I want to find out that David has a colleague in Workbook 1 who has an email address and then fill David's blank email space with take john@ibm.com. However, I do not have a lot of time so I want a quick solution. How do I effectively search for people with email adresses that work in the same company and then their email addresses to fill the blanks in the second workbook?


Thanks! Quick answer would be really appreciated and would make my day!
 
Fatou2010


Firstly, Welcome to the Chandoo.org forums.


Chandoo has written a number of posts on finding Duplicates


Can you please read the 3 Green Sticky posts at the top of http://chandoo.org/forums/

These posts explain how the Chandoo.org Forums work.


The Chandoo.org forums have a Google Search built-in. It is located at the Top right of every page.

This searches the posts at Chandoo.org and the Chandoo.org/Forums.

Try using that and searching for "Duplicate"
 
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 address? Thanks!
 
You must log in or register to reply here.
Back
Top