Help Identifying Duplicates

[ShannonH]

I would like to pull all of the duplicates out of a set of data. I want to see all of the duplicates, including the line it is a duplicate of.

For Example

2

2

4

3

4

6

6

For the above, I would want to see all the records except for 4 and 3. I want to see both of the 2s, 4s, and 6s. 

What is the easiest way to do this?

Thank you!

[Garrett]

Download/install the CReW Macro Pack and use the "Only Unique" tool.

[mceleavey · Accepted solution]

Hi @ShannonH,

This is a simple matter of grouping by the number and counting the occurrence of the number, then removing those where the count = 1.

I've attached the solution.

[ShannonH]

Perfect. 

[PeterGoldey]

Agreed that works.

But I would still recommend the Only Unique macro mentioned above.

When you have multiple columns you can:

• test unique across as few / many columns as you want
• retrieve (view) all the other columns for each record whether they are duplicate or not
• do this with a couple quick check boxes

[jacob_kahn]

Thank you - this really worked for me.