Remove Duplicate Entries in List

Hello,

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:

Please Login or Register  to view this content.

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.

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?

Thanks!

Hi,

There's really no need for macros for this sort of stuff. As a general rule use standard excel functionality wherever possible, even if you get a macro to compose it for you.

In this case with your list starting in A1, in B1 and copied down enter the following formula

Please Login or Register  to view this content.

Then just filter for the word 'duplicates' in column B and delete all the filtered rows.

HTH