• 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.

Rookie: Want simplest way to Remove Duplicates in Excel 2010 based on field #2

C

ckenyon21

New Member
HI there -


I have a marketing list of clients that includes email address and in some cases Salesforce ID. I want to remove duplicates from the email column, BUT I want to give a priority to keep the record that has a Salesforce ID, if any do.


What are the step by step instructions for something like this? Or where can I look to learn more?


SOOOOO appreciate the help!

CK
 
I'd sort your data first by the salseforce ID column so that all the rows with blank salesforce ID's are at the bottom.


Next, with the data selected, Go to the Data ribbon, Data Tool box, Remove duplicates. Uncheck everything except the Name field. XL will now automatically remove duplicate names, keeping the first entry (which we already made sure would be the one with a sales force ID).
 
Thanks - I didn't think about the order. So the Remove Duplicates function always picks the first one? Interesting!
 
You must log in or register to reply here.
Back
Top