Duplicates - deleting to get just unique ones

[koncept]

I have 2 lists of words. Some words from list 2. are on list 1. too.
Now I merge these lists into one list.
How can I obtain just unique words or unique words on the top of the
merged list?

TIA

 

[gls858]

I have 2 lists of words. Some words from list 2. are on list 1. too.
Now I merge these lists into one list.
How can I obtain just unique words or unique words on the top of the
merged list?

TIA

Check out this link provided by Pearson Software Consulting

http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

gls858

 

[swatsp0p]

Make sure your column has a Header name (e.g. in A1 enter "List") the
apply Data>Filter>Advanced Filter...check Unique Records Only.

HTH

Bruc

 

[koncept]

Make sure your column has a Header name (e.g. in A1 enter "List") then
apply Data>Filter>Advanced Filter...check Unique Records Only.

HTH

Bruce

Thank you for your reply.
Another problem is what to do to obtain just (!) those unique words?
(I mean words that don't exist on the other list - duplicates should
be deleted both).