Closed Thread
Results 1 to 2 of 2

How to identify then generate the differences between two data sets published.

  1. #1
    Registered User
    Join Date
    04-04-2013
    Location
    San Francisco, California
    MS-Off Ver
    Excel 2010
    Posts
    69

    How to identify then generate the differences between two data sets published.

    I have data from different months (February & March) lots of the data remain similar. I want to know if there is a way to identify what has changed between the data set and then generate a new sheet that only has the changes between the two months. Attached is the Data Set for reference. I placed March and Feb in different work sheets. Please help

    My old process was that I used to comb through all the data set and use the data I need. And replace all values. If there was a way I could determine what was change, I would only need to replace those values in a different table I need to make.

    Please Help.

    I really only care if column I has changed in respect to Column E, F, & G

    Column E is the name
    Column F, G, & I are attributes of column E
    Column F & G describe the range of which Column I is an attributed to the Name in Column E

    Example:

    Route 1245 (COLUMN E) has an MAOP of 890 (COLUMN I) between 0 (COLUMN F) - 400 (COLUMN H),

    Id like to know when the MAOP (I) with respect to E, F, & G has changed (if it does)
    Id like to know when F & G has changed with respect to E (if it does)

    Finally if there is a change to any attribute to F, G, and/or I, I'd like to know on which Route (E) it happens on.

    If you can imagine a simpler process to do this please share Changes Excel Help.xlsx

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: How to identify then generate the differences between two data sets published.

    New thread has been opened in Commercial Services.

    This thread is now closed.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Highlighting differences between two sets of data
    By Barking_Mad in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-02-2011, 11:44 AM
  2. How do I compare 2 sets of data and highlight differences?
    By Perplexed1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 AM
  3. How do I compare 2 sets of data and highlight differences?
    By Perplexed1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  4. [SOLVED] How do I compare 2 sets of data and highlight differences?
    By Perplexed1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  5. How do I compare 2 sets of data and highlight differences?
    By Perplexed1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-08-2005, 08:15 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