Results 1 to 5 of 5

Matching columns and outputting lists of corresponding values

Threaded View

  1. #1
    Registered User
    Join Date
    06-29-2010
    Location
    Hawaii, USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Exclamation Matching columns and outputting lists of corresponding values

    Hi, all. I'm new and am stuck with a problem in Excel 2007 with a lot of information (45,000 to 60,000 rows). Here's my problem:

    From one machine, I have the date, hour, minute, second, and a measured numerical value, and from another machine, I also have the date, hour, minute, second, and a measured numerical value.

    Whenever both machines took a measurement on the same day, at the same time (same hour, minute, and second), I need to know the corresponding numbers that both machines measured. I have an example below.

    First machine (columns A-E):

    Date Hour Min Sec Number
    2009-09-22 0 14 39 90
    2009-09-22 10 37 11 36
    2009-09-22 11 55 15 42
    2009-09-22 12 6 36 21
    2009-09-22 13 18 58 96
    2009-09-22 13 49 45 68
    2009-09-22 15 1 46 93
    2009-09-23 6 13 27 38
    2009-09-23 18 21 52 27
    2009-09-23 18 39 0 91
    2009-09-23 20 16 17 26


    Second machine (columns G-K):

    Date Hour Min Sec Number
    2009-09-22 5 59 39 18
    2009-09-22 9 3 17 9
    2009-09-22 10 8 41 39
    2009-09-22 11 55 15 61
    2009-09-23 13 15 58 28
    2009-09-23 13 12 56 66
    2009-09-23 15 1 46 48
    2009-09-23 20 16 17 2
    2009-09-24 18 21 38 31
    2009-09-24 23 34 0 78
    2009-09-25 3 1 58 46
    2009-09-25 14 34 7 75
    2009-09-25 14 59 26 57


    Ideal output would be this:

    42 61
    26 2


    I tried to make it as similar to my file as possible. One machine has more measurements than the other, so the lists are longer. Also, there may be more measurements taken on one day for the first machine, but less measurements taken on the same day by the other machine, so dates and times will not match up next to each other in rows.

    Thank you so much if anyone can help! I've been working on this file for practically 7 hours every day since last Thursday.
    Last edited by eila90; 07-09-2010 at 03:23 AM. Reason: solved

Thread Information

Users Browsing this Thread

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

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