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