With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
I've got a google spreadsheet that is scraping multiple sites for races where I live. I want to be able to sort out the duplicates in my final spreadsheet, but sometimes the sites list slightly different names for the races. I was hoping someone might be able to help me create a function that will take the first 4 characters in each cell and compare them to adjacent cells (the data is sorted A-Z by race name so that should be fine) and then delete one of the rows if the first four characters match. Any ideas? I was hoping there would be a way to define a range other than just cells using the UNIQUE function, but I don't think that's possible.