Find duplicates across several columns and show only first type

[Connor_McCormick1]

I think the approach I would take is to set up a filter so that you only show v1 and v2, then find and filter all duplicate rows:

Button to Delete Duplicates

I often find myself wanting a single button that will delete all columns with duplicate values. For example, imagine I have this table: [image] I want to remove either “Ben H” or “Ben Howit” because they have the same email address. But I don’t want to remove both. How can I do this in Coda? Well, I’m not the first to ask: Removing Duplicates by Email using a button Highlight duplicates in a column using a conditional format How to find out duplicate value on the row and delete it. Need h…

This post will show you the formula to find all duplicates (and optionally delete them)