Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7,247
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to compare two columns on two sheets and copy associated data from one sheet to the other? [email protected] Excel Worksheet Functions 2 June 22nd 07 03:40 PM
can I ignore words when sorting excel columns? Tomk Excel Worksheet Functions 1 June 18th 07 09:31 PM
compare two columns data and bring them to another work sheet EXCEL USER Excel Discussion (Misc queries) 1 February 14th 07 08:42 PM
How can I move several columns of words into one column in Excel? Landa Excel Worksheet Functions 6 May 9th 06 04:58 AM
Excel convert 1 row 5 words INTO 1 row 5 columns Kassie Excel Worksheet Functions 0 August 31st 05 07:03 AM


All times are GMT +1. The time now is 01:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"