Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-07-2014, 06:18 AM
gebobs gebobs is offline Comparing two sentences in two different columns Windows 7 64bit Comparing two sentences in two different columns Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Could you attach the file?
Reply With Quote
  #2  
Old 08-07-2014, 06:48 AM
JoAndRoPo JoAndRoPo is offline Comparing two sentences in two different columns Windows 7 32bit Comparing two sentences in two different columns Office 2007
Novice
Comparing two sentences in two different columns
 
Join Date: Aug 2014
Location: Mumbai
Posts: 3
JoAndRoPo is on a distinguished road
Default

Quote:
Originally Posted by gebobs View Post
Could you attach the file?
I'm sorry, I can't. I'll try to elaborate my problem.

I have written down about 100 sentences in an excel sheet (version 1) a long time ago. And those same 100 sentences was copied and pasted in a xml (version 1). But note, I jumbled up those sentences intentionally in the xml.

But a few days later I updated a few sentences in the excel sheet (version 2). But I'm not sure if I added all the updated sentences in the xml (version 2).

So I copied the sentences from from the xml (version 2) and pasted them in the excel sheet (version 2), in column B. The updated sentences in the excel sheet (version 2) is placed in column A.

I now added a formula [=exact (A1, B1)] in column C and dragged that cell all the way down. Remember as I have mentioned earlier, I jumbled up the sentences in the xml intentionally. Which means, in column C where I have added the formula, it shows False. That's because, none of the sentences in column A and B are in the same row.

Is there any way to place the same sentences even with a minor detail difference in the same row? That way I can differentiate if there's even a full stop missing from the sentence.

I hope you can understand the above problem I'm facing.

Thanks for replying.
Reply With Quote
Reply

Tags
columns, comparison



Similar Threads
Thread Thread Starter Forum Replies Last Post
Error comparing and getting result of between Two columns shilabrow Excel 4 06-19-2014 03:36 AM
Comparing two sentences in two different columns Comparing 2 columns of Text Berk21 Excel 9 02-03-2012 12:19 PM
Comparing two sentences in two different columns Advanced Filter - Comparing Two Columns apolloman Excel 5 07-27-2011 04:54 AM
Comparing two sentences in two different columns How to compare 2 columns with other two columns in EXECL 2007? Learner7 Excel 5 06-12-2010 09:54 AM
macro for comparing data from 3 columns and pasting into another worksheet ashukla Excel 1 06-24-2009 05:01 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:05 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft