Formula to Determine Partial Duplicate Content - Possible?

[Southerncentralrain]

I have a sheet with writings that I would like to determine if there are more than 50 characters in a row that are exactly like the other writings. In other words, if there is a sentence in the writing that is the same sentence as another writing, I would like to be notified. The notification could be "Duplicate Content" listed in the adjacent cell.

Is this possible? Thanks in advance for your time.

 

[Aladin Akyurek]

I have a sheet with writings that I would like to determine if there are more than 50 characters in a row that are exactly like the other writings. In other words, if there is a sentence in the writing that is the same sentence as another writing, I would like to be notified. The notification could be "Duplicate Content" listed in the adjacent cell.

Is this possible? Thanks in advance for your time.

Let's change 50 to just 3 and provide some example data to show what is desired...

 

[Southerncentralrain]

This is a very obvious example but this content is pretty much the same except some words.

B2 = A beautiful outdoor lantern isn't going to do you much good if you don't have a high-quality post to support it. This Legendary Lighting Steel Lantern Post is the perfect companion for any Legendary Lighting lantern with a post bracket. Its steel construction offers durability while its classic design provides an attractive visual compliment for your lamp.

B3 = A beautiful outdoor lantern isn't going to do you much good if you don't have a high-quality post to support it. This Legendary Lighting Steel Lantern Post with Decorative Cast Base is the perfect companion for any Legendary Lighting lantern with a post bracket. Its steel construction offers durability while its classic design provides an attractive visual compliment for your lamp.

I would like for C2 and C3 to say "DUPLICATE CONTENT" if possible.

Does that make sense?

 

[Aladin Akyurek]

This is a very obvious example but this content is pretty much the same except some words.

B2 = A beautiful outdoor lantern isn't going to do you much good if you don't have a high-quality post to support it. This Legendary Lighting Steel Lantern Post is the perfect companion for any Legendary Lighting lantern with a post bracket. Its steel construction offers durability while its classic design provides an attractive visual compliment for your lamp.

B3 = A beautiful outdoor lantern isn't going to do you much good if you don't have a high-quality post to support it. This Legendary Lighting Steel Lantern Post with Decorative Cast Base is the perfect companion for any Legendary Lighting lantern with a post bracket. Its steel construction offers durability while its classic design provides an attractive visual compliment for your lamp.

I would like for C2 and C3 to say "DUPLICATE CONTENT" if possible.

Does that make sense?

See whether you can use:

http://www.mrexcel.com/forum/showthread.php?t=195635