![]() |
|
#1
|
|||
|
|||
![]()
Could you attach the file?
|
#2
|
|||
|
|||
![]()
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. |
![]() |
Tags |
columns, comparison |
|
![]() |
||||
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 |
![]() |
Berk21 | Excel | 9 | 02-03-2012 12:19 PM |
![]() |
apolloman | Excel | 5 | 07-27-2011 04:54 AM |
![]() |
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 |