Thursday, January 26, 2012

yogi_Extract Non-Duplicated Cells Meeting Specified Criterion

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

user trivox2 said:
reference spreadsheet:
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