Data processing rule # 1: Clean up your data before trying to process it.Originally Posted by snb
I don't offer ineffectual or unnecessary solutions. If you complete the code for all typos and run it on all incoming data. you will have consistent data. Your sample has almost 500 rows. I ran that code on the entire sheet and it was done literally in the blink of an eye and eliminated 25 of at least 26 duplicate sets of data. If you create a dictionary array list on a sheet as I suggest, it will very easy to maintain as new typos appear. Which they will.
Reply With Quote