I have a list and I would like to remove all of the entries that are duplicates in that list. I tried using the macro from microsoft (http://support.microsoft.com/kb/291320) but for one of the three lists where I try to remove the duplicates, it still returns two of the same value (I have e,t,t,e,t,e and it returns e,t, and e.). I am not sure why it would work for a few lists, but then not work for one list. Here is the code I'm using:
I tweaked it a little from the microsoft site; did I mess it up somehow? All I added was some code before the duplicate-removal piece which makes the list, and then at the end which puts the values of the duplicate-removed list in some different cells.
Please Login or Register to view this content.
Does anyone know why this code won't work for some lists and work for others? Is there much simpler code somebody could offer that would look at a column of data and remove the duplicates?