Results 1 to 5 of 5

How to compare the similarity of 2 cells?

Threaded View

  1. #1
    Registered User
    Join Date
    02-03-2012
    Location
    Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    23

    Question How to compare the similarity of 2 cells?

    Hi guys, I want to compare the similarity of the 4-digit primary SIC code of an acquirer, and the 4-digit primary SIC code of a target. It's for my Master's thesis.

    If the first digit of each code doesn't match: similarity = 0
    If the first digit of each code matches: similarity = 1
    If the two first digits of each match: similarity = 2
    If the three first digits of each matches: similarity = 3
    If the all the digits of each code matches: similarity = 4

    What is the right formula?

    Example:

    Acquirer SIC Target SIC Similarity
    1896 1896 4
    1963 1900 2
    6952 6327 1
    5369 5369 4
    6321 6312 2
    Last edited by glux; 07-29-2012 at 03:43 AM. Reason: Problem solved!

Thread Information

Users Browsing this Thread

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

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