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!

Help Identifying Duplicates

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

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!

Output

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

For ShannonH.PNG

I've attached the solution.

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

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

For ShannonH.PNG

I've attached the solution.

Perfect.

Thank you - this really worked for me.