Macro for removing duplicate rows in Google Spreadsheet — fast version

This macro allows to check which entries on a sheet are duplicated in another, and deletes them. Instead of deleting one by one, which in GoogleSheets is extremely slow, the algorithm gets the runs of matches (e.g., starting in position K there are N matches) and then deletes them by blocks. The worst case scenario would be if the matches were intermittent, in such case the performance would be as bad as deleting one by one.

 

Deja un comentario