+ Reply to Thread
Results 1 to 2 of 2

Comparing differences between two columns

  1. #1
    Registered User
    Join Date
    11-02-2010
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    2

    Comparing differences between two columns

    Hi

    I have used an If function to compare two columns and have match or mismatch. For the mismatches, I'd like to see how different they are. Is this possible.

    IE

    Column A Column B Similar/Different
    ABC Holdings XYZ Corp Different
    ABC Holdings ABC Holdings Plc Similar

    Thanks in advance

    (I'm using Excel 2002)

  2. #2
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: Comparing differences between two columns

    I would suggest that more details are required here.

    For eg. Start with different letters (the first 2,3,4,5,6 letters) have/dont have numbers/text in?

    Maybe upload a sample of your desired output
    Blake 7

    If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

    If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.

    http://failblog.org/

+ Reply to Thread

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