+ Reply to Thread
Results 1 to 2 of 2

most condensed way to compare two rows and highlight differences

  1. #1
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    most condensed way to compare two rows and highlight differences

    Hi guys and girls,

    I pull data from a site which produces rows with 60 cells of data.
    Each time rows get pulled in, and it could be duplicates.

    Now I want to compare if the row I pull in already exists - I do this via a simple countif on a unique id.
    Then I compare the rows via:

    Please Login or Register  to view this content.
    If that returns false, there's differences between the two rows.

    Question I have is - how can I capture which columns are different between the two rows, without looping through them (because that would mean looping 60 cells).
    Basically I want to return the column headers of the columns which differ into a string - in as little lines of code as possible

    Any assistance is greatly appreciated.

  2. #2
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: most condensed way to compare two rows and highlight differences

    Solved it differently.
    I populate the 60 cells one by one from a JSON element
    So instead of populating, checking if there's a match, then checking for differences -I populate as :

    Please Login or Register  to view this content.
    That leaves only the differences and eliminates the duplicates.

+ 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. [SOLVED] VBA to compare and highlight differences
    By REFisher14 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-19-2014, 03:18 PM
  2. [SOLVED] Compare rows and highlight differences
    By cheeze83 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-29-2013, 04:38 AM
  3. Compare two lists and highlight the differences
    By jsmo in forum Excel General
    Replies: 3
    Last Post: 08-28-2012, 10:27 PM
  4. compare 2 rows at a time and highlight differences
    By teej in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-29-2009, 02:25 PM
  5. Compare two lists and highlight differences.
    By delgadotb in forum Excel General
    Replies: 1
    Last Post: 03-30-2009, 03:24 PM

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