Duplicates - deleting to get just unique ones

  • Thread starter Thread starter koncept
  • Start date Start date
K

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
 
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
 
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
Click to expand...


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).
 
Back
Top