Remove Email Duplicates

Hi,

I would like to seek your ideas on how I am going to remove email duplicates. for example in a report is teddy123@yahoo.com<teddy123@yahoo.com> will give an output of teddy123@yahoo.com. It will remove the <teddy123@tyahoo.com>. In one field it may consist of multiple emails with duplicates and I would like all duplicates to be remove. Please see sample attachment for your reference.

Please advise for the formula to use.

Thanks and hoping for your response.

Kamen

sample email report.xlsx

Workflow

Reporting

Regex

Custom Tools

Common Use Cases

Accepted answers

ScottE

Hi @KamenRider

This should work for any number of fields.

Hope it helps.

Scott

RemoveDuplicateEmails.yxmd

All comments

Kakuffo

HI @KamenRider will the duplicates be across multiple fields or within a specific field?

JamesCharnley

Hi @KamenRider

Something like this would work:

Someone might be able to 1 tool this in a formula but I like to break it down if it'll take me less time to do than in a formula!

CleanDuplicateEmails.yxmd

KamenRider

Hi @Kakuffo

Duplicates can be found in different or multiple fields. Kindly see my sample attached.

Kamen

KamenRider

Hi @JamesCharnley

I think you are getting the solution I am looking for however I do have an error when I run it to my file. Maybe because my file has to many columns compare to the sample I gave you. Suggest to kindly check sample attached which corresponds to the file I am using.

Looking forward for an update in the workflow.

Thanks,

Kamen

Sample2.xlsx

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703