Creating a button to identify & remove duplicate rows


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

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.



The formula is below.

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

Here’s an example of how to do this:

And here’s a quick illustration of it working:


@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.