+ Reply to Thread
Results 1 to 2 of 2

Matching two data sets

  1. #1
    Registered User
    Join Date
    07-24-2013
    Location
    CA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Matching two data sets

    Hi, I have a problem!

    I have two data sets. They each have a date and a value. The problem is that one data set has more dates with values than the other. I need to delete the extra ones so that the two data sets match. Ideas?

    Example:
    1/17/2002 252.036 1/17/2002 180.27
    1/18/2002 258.177 1/18/2002 180.22
    1/22/2002 257.372 1/21/2002 177.06
    1/23/2002 260.43 1/22/2002 178.19

    See how the 21st messes up them matching? How do I get rid of the extra data points on the right?

  2. #2
    Forum Contributor
    Join Date
    06-26-2013
    Location
    LAX
    MS-Off Ver
    Excel 2007,Excel 2010
    Posts
    363

    Re: Matching two data sets

    Hello,

    See if the attached file helps you in someway. If this is not you are looking for, please attach an excel sheet with input data and desired result.
    Attached Files Attached Files

+ 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. Trouble matching sets of data through VBA
    By turbonerds in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2013, 11:17 PM
  2. Matching Addresses between two sets of data
    By ceej561 in forum Excel General
    Replies: 4
    Last Post: 02-20-2012, 10:05 PM
  3. Matching two data sets
    By sbarnhar in forum Excel General
    Replies: 8
    Last Post: 11-03-2009, 12:31 PM
  4. Matching two sets of Data
    By ikflash in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-18-2008, 03:32 AM
  5. Matching Two sets of Data and Get a New Output Sheet
    By crapmind in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-25-2007, 03:48 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