+ Reply to Thread
Results 1 to 3 of 3

Compare two columns and return differences

  1. #1
    Registered User
    Join Date
    11-07-2016
    Location
    MN, USA
    MS-Off Ver
    365
    Posts
    4

    Compare two columns and return differences

    Hello All,

    This is my first post on the forum so let me know if I am doing this right.

    I have a column G and column H that have text in it. I need to compare the two columns and see what changes have been made from one column to the other.

    I tried the =Subsitute(G2,H2, ""), but this did not work. I am unsure what I am doing wrong. Any information helps thanks

    G H results
    Thick & Crmy Vanilla 6 oz Thck Crmy Lf Ygrt Vanilla 6 oz i& Lf Ygrt

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Compare two columns and return differences

    what do you mean by "see what changes have been made"?

    ie if G1 = "ABC" and H1 = "AZZ" do you want the row highlighting? or do you want to highlight the fact letters 2 and 3 are different?
    If someone has helped you then please add to their Reputation

  3. #3
    Registered User
    Join Date
    11-07-2016
    Location
    MN, USA
    MS-Off Ver
    365
    Posts
    4

    Re: Compare two columns and return differences

    Sorry That wasn't clear. I want to know what the exact changes are in a new column Z. Column Z is like a results column. So if G = ABCD and H = DCEF the Results column Z would return 'ABCEF" since that is the difference between the two strings. I hope that makes more sense

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Compare character strings in 2 cells and return only the differences
    By Barcenal28 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-09-2015, 05:12 PM
  2. Replies: 1
    Last Post: 03-06-2015, 01:07 PM
  3. Replies: 0
    Last Post: 07-17-2014, 10:06 AM
  4. Compare Worksheets and Return Differences
    By bkeller83 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-16-2009, 01:52 AM
  5. [SOLVED] Compare 2 columns to see differences
    By JE McGimpsey in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2005, 07:05 AM
  6. [SOLVED] Compare 2 columns to see differences
    By JE McGimpsey in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 06:05 AM
  7. [SOLVED] Compare 2 columns to see differences
    By Bugaglugs in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-12-2005, 11:05 PM

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