How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Richard Your Own Question

Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 30207
Experience:  Over 15 year experience resolving Microsoft Office Issues
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

I have a spreadsheet with about 20,000 entries, half of which

This answer was rated:

I have a spreadsheet with about 20,000 entries, half of which have duplicate emails. I need to find all of the duplicate emails and change the email column of the entry to "[email protected]" Is there an easy way to do this without going through each and every entry?

Some more information about the spreadsheet: There are about 20 columns of data. The first three are: email, token, and date modified. the next 17 or so are Flags with either a Y or N for each entry. The only one I need to change is the email column of the duplicate with the earlier modified date. Currently I have the sheet filtered in alphabetical from a to z, so I see all of the duplicates next to each other.

Does this make sense? Let me know if I can clarify more.
Thank you for your question, my name is Richard.

I can write a macro to do this for you.

It is easiest if I do this directly into the sheet. Can I therefore see the file please?

- Click the following link:
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"

Thank you
Customer: replied 3 years ago.

Hi Richard,

The File ID is: 503994


Thank you


Also we block email addresses due to privacy, but I need it for this

Can you repeat it but leave a space before and after the @ please

eg: richie @

Customer: replied 3 years ago.

test @

thanks, XXXXX XXXXX it now
it is running now, will post it when it completes.

Customer: replied 3 years ago.

thank you, XXXXX XXXXX have any kind of time estimate for how long it will take to run?



No sorry, it is running, and has a lot of records to check, but the moment it finishes I will post.

Should not be longer then 30 minutes.

Customer: replied 3 years ago.

Great, thank you