Filter out duplicates

Question

Hi Everyone,

I wish to filter out duplicates values from a file and I am not able to do it with the Unique tool nor the Summarize tool.

I need all occurrences of the same data to be filtered out, not keeping one.

In the example attached, I would need to filter out rows that have the same values in headers 1/2/3/6/7. In this case rows 2 to 5.

Can you please help me?

Many thanks,

Benjamin

Filter out duplicate example.xlsx

JosephSerpis · Accepted Answer

Hi @BenjaminLaudereau you can use the Unique tool and the Join tool to get all of your truly unique data.