I've a CSV file with 10,000+ rows. For the sake of simplicity lets say there are three columns in each row
Date
Counter
Textfield
The values in the textfield column in about 900 of the rows contain duplicates and I need some way of automatically finding and appending some standard text to the end these fields in the rows with the lowest counter AND the oldest date. Can this be done with a macro? Or some manipulation / comparison of additional counter columns?
Oh and in most cases there are just two duplicates, but some have between three and nine. I'm hoping that whatever voodoo used to find matching pairs can just be run N times until all dupes are gone.
So - anyone able to help?
Date
Counter
Textfield
The values in the textfield column in about 900 of the rows contain duplicates and I need some way of automatically finding and appending some standard text to the end these fields in the rows with the lowest counter AND the oldest date. Can this be done with a macro? Or some manipulation / comparison of additional counter columns?
Oh and in most cases there are just two duplicates, but some have between three and nine. I'm hoping that whatever voodoo used to find matching pairs can just be run N times until all dupes are gone.
So - anyone able to help?