Compare the words in columns of the excel sheet

[MajesticM]

Hello...

I have a list of words in Column A and another list in Column B. i wanted to
compare the data between the columns and get the results into a log file.
Need some suggestions here

 

[Chip Pearson]

You need to provide much more detail. What, specifically, does "compare the
data" mean and what are the "results" that need to be written to a log file.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[MajesticM]

Data is the words eg: CNN, IBM, NDTV,NBC words in column A and HBO, ESPN,
STAR, CNN in column B. I need to comparen between column A and column B.

if A1:B1 did not match, then I need to put in log file as the A1 data and B1
data did not match.