Hello:


I have 2 separate text file each containing a bunch of IP addresses.
The first text file (TextIP-1.txt) contains 100 IP addresses; list 1
below the other.
The second text file (TextIP-2.txt) contains 56 IP addresses; listed 1
below the other.

I am looking to compare the content of these 2 text files & identify those
overlapping IP addresses that exist in BOTH of these text files.
Maybe the results can be printed to a third text file. Any help appreciated.

* Is there a simple Excel function that can achieve this objective ?


Thanks in advance.
Jo.