Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
user trivox2 said:
reference spreadsheet:
https://docs.
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.
-------------------------------
following is a solution to the problem
No comments:
Post a Comment