Compare the words in columns of the excel sheet
 

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

Compare the words in columns of the excel sheet
 

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" wrote in message
...
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

Compare the words in columns of the excel sheet
 

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.

"Chip Pearson" wrote:

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" wrote in message
...
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