+ Reply to Thread
Results 1 to 3 of 3

Uncovering similar text in cells

  1. #1
    Registered User
    Join Date
    02-16-2005
    Location
    Rome, Italy
    MS-Off Ver
    2010
    Posts
    40

    Uncovering similar text in cells

    Hi there, I have a small project where individuals need to submit a survey reply. However, I want to chase people that just copy & paste their replies into the survey or just slightly modify them.
    Therefore, I would like to uncover the "similarity %" of text in various rows.

    Example:

    cell a1: The dog has a long tail.
    cell a2: The dog has quite a long tail.
    cell a3: The cat has grey eyes.

    Affirmation 1 and 2 are very similar although not identical. What suggestions do you have for me to uncover these, as they are not identical but sill too similar to be considered different?

    I have a list with around 1000 responses and, I would like to uncover those that are very similar to others.

    Thanks for your thoughts on this.

    Titus

  2. #2
    Valued Forum Contributor StevenM's Avatar
    Join Date
    03-23-2008
    Location
    New Lenox, IL USA
    MS-Off Ver
    2007
    Posts
    910

    Re: Uncovering similar text in cells

    You might want to take a look at the following:

    http://www.excelforum.com/excel-prog...detection.html
    http://www.excelforum.com/excel-gene...ercentage.html

  3. #3
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    26,987

    Re: Uncovering similar text in cells

    Hi,

    How long is a piece of string?

    Basic Excel does not have any sort of fuzzy analysis. It could also be said that a3 is similar since it mentions an animal and an adjective describing one of its organs, but I suspect you don't classify that as similar.

    Only if you can define some very specific rules would you have any chance of achieving some textual analysis but in reality I doubt that you can easily achieve this with Excel.
    Last edited by Richard Buttrey; 06-26-2012 at 06:39 AM.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1