How to get all duplicates in 1 list

soncoku

Hey everyone.

I have this long list of name where I have duplicates (sometimes even 9 repetitions of the same name).

If I use the duplicate tool it does give me the duplicates but it keeps one in the list of the Unique results.

For example:

1. England

2. Spain

3. England

4. England

5. England

The Unique tool would give me this result :
Unique: Englad, Spain
Duplicate: England, England, England

What I want to achieve is to have all records that are repeated in 1 list.

Like this:

Unique: Spain
Duplicate: England, England, England, England

Any ideas?

Workflow

Accepted answers

Emil_Kos

Hi @soncoku,

probably not most efficient solution but it works.

Duplicates.yxmd

grazitti_sapna

@soncoku , I thought you were looking something for solution like you mentioned in your post anyways I have an easier approach if it helps.

Thanks.

How to get all duplicates in 1 list-GS-updated.yxmd

All comments

JosephSerpis

Hi @soncoku I mocked up a workflow that showcases how to do that. Let me know what you think?

Duplicate_09102020.yxmd

Emil_Kos

Hi @soncoku,

probably not most efficient solution but it works.

Duplicates.yxmd

atcodedog05

TheOC

Hi @soncoku ,

I managed this with two summerize tools, please find attached my workflow of how this was done:

I ran with this input:

and ended with an output as you asked:

Let me know if i can help any further!

soncoku.yxmd

grazitti_sapna

Hi @soncoku , give this a try.

Thanks.

How to get all duplicates in 1 list-GS.yxmd

soncoku

@atcodedog05 I use the Unique tool everyday but it doesn't help me with this situation 😕

soncoku

@TheOC good one but you concatenate everything in one cell.

I reality I have a list with +1000 rows with at 47 cols, that doesn't make my job easier 😛

soncoku

@Emil_Kos The solution I was looking for.
Thank you 🙂

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703