Remove duplicate rows from google spreadsheet

I needed to remove duplicate rows from a google spreadsheet and regex the last part of the string for each row

I had a specific work case where I should go through a long list of urls and had to extract the string from the last “/”. I was given a long list of URLs, and with no intention of going through each of them manually, I decided to speed up things a bit with a little Google Spreadsheet scripting. I then noticed that there where duplicate URLs in my list – eeek, I need to remove duplicate rows.

Read More