Creating a button to identify & remove duplicate rows

#1

Hi All.
@mallika had a great solution to filter and identify duplicate rows in the below thread.

https://community.coda.io/t/showing-only-the-unique-rows-in-a-table-without-repeats/1466

I was keen to create a button that removes the duplicate rows. using mallika’s formula, but have com up short, seems like no matter how i modify it, it just deletes everything. If anyone has any ideas it would be greatly appreciated.

Cheers,

Paul.

The formula is below.

Showing only the unique rows in a table without repeats
Find Unique Matches in Another Table
#2

Here’s an example of how to do this: https://coda.io/d/Example-Remove-Duplicate-Rows_d-ibl9IOYLo

And here’s a quick illustration of it working:

7 Likes
#3

@shishir Amazing thank you so much. This works perfectly. At first i was thinking that it all should be in one super formula attached to the button, but splitting it up into a couple of rows makes it so much easier to digest and is much more illustrative for another editor to come in and manipulate.

Thank you again.