Deleting multiple similar words...?

[silveraden]

Hi, I'm new to this forum and I want to ask some help about excel..

My first question is, is there any option to delete multiple repeated words in different rows?

Example:
name
name
name
name
fine
fine
fine
okay
okay
okay
same
same

Can we just filter it to:
name
fine
okay
same

Please tell me the way if there is....

Thanks a lot

[VBA Noob]

Hi,

You could use Advance Filter to extract a list of unique items

http://www.contextures.com/xladvfilter01.html#FilterUR

Or say your data in Column A starting in A1 enter this formula in B1 and drag down

=SUMPRODUCT(--($A$1:A1=A1))

Then using Filter > custom > filter on greater than 1 and delete hightlighted rows

http://www.contextures.com/xlautofilter01.html#Custom

Another option is a macro

VBA Noob

[silveraden]

Thanks a lot... I will try this one..anyway, I am using excel for 6 years but I have no idea about macro...is there any tutorial?

Thanks once again

[VBA Noob]

The Link below on my autosignture has useful links about VBA.

But here are a few links to delete duplicates that you may be able to follow

http://www.vbaexpress.com/kb/getarticle.php?kb_id=135

http://www.ozgrid.com/VBA/RemoveDuplicates.htm

http://www.cpearson.com/excel/deleting.htm

Also search this forum for examples

VBA Noob