Closed Thread
Results 1 to 5 of 5

Need help comparing data and returning changes.

  1. 02-24-2014, 12:58 PM #1
    tiffnh2002
    tiffnh2002 is offline
    Registered User
    Join Date
    02-24-2014
    Location
    Houston, TX
    MS-Off Ver
    Excel 2010
    Posts
    3

    Need help comparing data and returning changes.

    I would like compare data using a certain column to key off of and compare whether data has changed.
    I have 5,000 rows and 26 columns. Cell C1 is CALLED PMNUM, cell I1 is called CHANGEDATE
    I want to find all of the same PMNUMs (C2-C5000), look at the last change date (I2) (sorted in descending order), compare it to the previous change date (I2) and if anything has been changed in columns D2 through G2 and J2 through Z2 compared to the last time the data was reported, list the changes in in AA2.
    I have attached the spreadsheet. Help
    Reply With QuoteRegister To Reply
  2. 02-24-2014, 01:00 PM #2
    satabp
    satabp is offline
    Forum Contributor
    Join Date
    12-09-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    171

    Re: Need help comparing data and returning changes.

    Please attach the sample file
    Like my answer, then click * below
    Reply With QuoteRegister To Reply
  3. 02-24-2014, 01:12 PM #3
    tiffnh2002
    tiffnh2002 is offline
    Registered User
    Join Date
    02-24-2014
    Location
    Houston, TX
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Need help comparing data and returning changes.

    Ok I had to cut it down to 2,705 rows to be able to upload it.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 02-24-2014, 02:25 PM #4
    tiffnh2002
    tiffnh2002 is offline
    Registered User
    Join Date
    02-24-2014
    Location
    Houston, TX
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Need help comparing data and returning changes.

    See attachment above. Thank you :-)
    Reply With QuoteRegister To Reply
  5. 02-25-2014, 02:04 AM #5
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Need help comparing data and returning changes.

    Thread posted in CS, hence closed.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
Closed Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Returning best matches after comparing data from 2 different sheets
    By Dolke in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-26-2013, 03:33 AM
  2. multiple data, comparing and returning data
    By Meka Owethu in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 05-21-2012, 04:42 AM
  3. [SOLVED] Comparing values across sheets and returning another set of data based on comparison.
    By graveyardshiftee in forum Excel General
    Replies: 6
    Last Post: 02-22-2012, 11:26 AM
  4. [SOLVED] Comparing and Returning
    By scottdog129 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 06-01-2011, 02:54 PM
  5. [SOLVED] Help comparing data and returning information...
    By dcjames in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-05-2005, 12:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1