Filter to just rows with duplicate values

Question

Hi,

I'm trying to figure out how to just see the rows in my data set that have duplicate values within each row.

For example, in some of my rows, there will be cells with the same information in multiple columns of the row. I want to focus in on just those, and get rid of the rest.

I tried using the Unique function, but that didn't get at everything I need.

Thanks for the help!

tcroberts · Accepted Answer

I would generally use a Formula Tool that looks at something like:

IF [Field1] = [Field2] OR [Field3] = [Field4]

THEN 1

ELSE 0

ENDIF

And then filter based on that new field.

If you provide a sample of mock data I can put together a more concrete example for you.

EDIT: Another alternative might be to Transpose your data, find uniques in the transposed version, then CrossTab back, but it is difficult to be sure without some sample data.

Cheers!