Quote:
Originally Posted by gebobs
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.