• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

comparing 2 lists of names

GODZILLA

New Member
Hello,


Im sure i saw a post before where chandoo had 2 lists of names and he made a list new list of unique names only in a third list.


i.e.


List 1:

Cat

dog

mouse

bat


list 2:

cat

bat

flag

hammer


list 3:

Cat

dog

mouse

bat

flag

hammer


How is this done?


Thanks
 
Advanced Filter using the Unique qualifier

Data, Sort & Filter, Advanced Filter

Copy to another place - Tick

List Range - the range with you combined list

Criteria Range - leave blank

Copy To - where do you want the combined list

Unique records only - Tick


or goto http://chandoo.org/wp/2008/08/01/15-fun-things-with-excel/

Item 2
 
Back
Top