Remove Email Duplicates

[KamenRider]

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

[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!

[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

[ScottE · Accepted solution]

Hi @KamenRider 

This should work for any number of fields.

Hope it helps.

Scott

[KamenRider]

Thank you @ScottE, you nailed it. :-)

Kamen