Forum Moderators: buckworks & skibum

Message Too Old, No Replies

Removing Duplicates from a KeyWords List... Help!

         

GuitarZan

6:17 pm on Mar 14, 2004 (gmt 0)

10+ Year Member



Hey,

I am having a really hard time finding out how to remove KeyWords from a list, that there are 2 or more of. I use Excel, but the way I used to do it, doesn't work anymore.

Are there any online tools, that will de-dupe a list of Keywords?

Thanks,

C.K.

Mardi_Gras

6:30 pm on Mar 14, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



There are no online tools that I know of. DigDB is a good desktop tool, and about the only one that has a free trial available.

You can also use the Data>Filter>Advanced Filter command within Excel, checking the Unique Records Only checkbox.

MrSpeed

1:48 pm on Mar 15, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I use a nifty little text editor called TextPad. There is an option to sort and remove duplicates. It's perfect for a keyword list.

For more complicated things I import the data into Access and set the field I want to remove the dupes from as the primary key.