Comparing and Extracting unique Values

N

ntesic

Hi,

I'm new to excel and am interested in finding out how to perfom th
following.

I have two seperate mailing lists, they both contain names, addresse
etc.

What I want to do is compare the company names of both lists an
extract entire rows of information for those that are unique.

For example:

I have 2 lists one containing the values ABC and the other containin
the values ABD. I want to be able to make a new sheet containg the tw
unique values C and D.

Is there a formual or macro I can run to do this operation? If there i
please post a link to where I may find the info.

Thanks,

Ne
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
how to compare formula's values? 4
Comparing two columns and returning value from another column 1
Get sum of values in a cell based on unique values in another cell 3
Creating unique keys 2
Extract Text in braquet and list of terms from 2 Docs 3
Compare columns pull unique values and first duplicate value 0
Error generating a list of unique values in range (XL2003) 2

Top