how to sort two LARGE columns

[apeagle]

I have a list of domains (about 200,000) that looks like this:
http://cat.com
http://dog.com
etc..

I have a list of urls (about 1 million) that looks like this:
http://cat.com/catsrule
http://cat.com/catsareawesome
http://dog.com/dogsaregreat
http://frog.com/frogsrock

I want my results to only show this (since this is the only thing in the second file that does not contain anything from the first file):
http://frog.com/frogsrock

I have tried programs designed to do this but they either (a) shorten everything down to the domain or (b) wont remove anything since the domains are part of a longer url in the second file. Thank you for any help that you all can provide!

[XOR LX]

Hi,

"...this is the only thing in the second file that does not contain anything from the first file"

I think you're going to need to be a bit more specific so that a meaningful solution can be found. For example, can you refine your statement to something along the lines of:

"I want to return only URLs for which the substring obtained between "http://" and "." is not found in any of the domains."

If this is not the case, could you rephrase it so that we have a logical rule governing which part(s) of the strings are to be compared?

Regards

[:) Sixthsense :)]

In Column-A
http://cat.com
http://dog.com
etc..

In Column-B
http://cat.com/catsrule
http://cat.com/catsareawesome
http://dog.com/dogsaregreat
http://frog.com/frogsrock

In C1 Cell

=IF(COUNTIF(A:A,"*"&LEFT(SUBSTITUTE(B1,"http://",""),FIND("/",SUBSTITUTE(B1,"http://",""))-1)&"*"),"",B1)

Drag it down..

Use a filter in Column-C and select nonblank or use pivot table by keeping Column C as source.

[apeagle]

Hi,

"...this is the only thing in the second file that does not contain anything from the first file"

I think you're going to need to be a bit more specific so that a meaningful solution can be found. For example, can you refine your statement to something along the lines of:

"I want to return only URLs for which the substring obtained between "http://" and "." is not found in any of the domains."

If this is not the case, could you rephrase it so that we have a logical rule governing which part(s) of the strings are to be compared?

Regards

I apologize and thank you for your help. I want to return only urls from column b that do not contain any of the string of text(s) in column a.