hello all,
I have a looooong column of data entries but there are repeat entries for many values. What is a good way of going thru the list from the top and removing any entries which repeat.
The data is sorted in a particular order, so I can't re-sort it and make all the same entries appear together and delete manually.... ( and in any case, I wouldnt want to delete them manually)
I am pretty new to VBA but was thinking of looping thru the column of entries, with an If Then conditional, and putting the entry to a new column, if it had not appeared in this new column previously? But not sure how to accomplish this or if this is the best way to do it. Really appreciate any hep and advice.
Thanks,
Kai
Bookmarks