File comparison

[Guest]

Folks:


I have 2 separate Excel files. Each file contains about 100 symbols. I would
like to run a quick COMPARISON
the content of these 2 files in order to identify those symbols words that
appear in BOTH files.
Finally I would like to write the results to either of the original files or
maybe to a third Excel spreadsheet.

* Is there an excel function or program that can achieve this objective ?

Deeply appreciate any assistance with this problem ?


P.S. Would it be better to first bring the content of both files into
separate columns of the same spreadsheet ?



Thanks,
Jo.

 

[Guest]

http://www.cpearson.com/Excel/whatsnew.htm

Look for Compare.xla