Thursday, January 26, 2012

yogi_Extract Non-Duplicated Cells Meeting Specified Criterion


Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

user trivox2 said:
reference spreadsheet:
https://docs.google.com/spreadsheet/ccc?key=0Aj7xwed9XeVNdFc3Mjc1UGdQZjBsVThjaWppaDZnaXc
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