compare lists?

[mike82]

I have two lists with a bunch of URLs in them. Some of the URLs are in both lists. Is there a tool that will show me the URLs that are in both lists?

There are hundreds and I can't go through them manually.

Thanks.

 

[John]

combine the lists and then let excel do it

 

[CShoemaker]

Duplicate Content Software - Duplicate Content Software SEO software that checks keyword density and more.

 

[mike82]

How do I do this in Excel?

Thanks

 

[argh01]

just text lists? Cat them together and sort them, taking out the uniques ( in linux ):

cat file1 file2 | sort -u > outputfile

 

[ret]

Depending on what you need to do with the data afterwards you can use vlookup, sumproduct, or filter unique in Excel.

=vlookup(A1,$D$2:$D$2000,1,false) This lets you maintain the two lists separately and compare them to each other.

=sumproduct(--($A$2:$A$2000=$A2)) where the array is your combined list, this would display the number of times it appears in the list total.

and toolbar data > filter and check unique to just dedupe the combined list if thats all you need.

 

[adamfsz]

How do I do this in Excel?

Thanks

Which version are you using? Conditional formatting will sort you out.