+ Reply to Thread
Results 1 to 4 of 4

Different sized range comparison

  1. #1
    Registered User
    Join Date
    07-19-2010
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    14

    Different sized range comparison

    I'm looking for a way to compare information across two differing sized ranges. The number of rows in columns in the two ranges also differs from day to day. But basically it's columns A to F where column C has a persons name and Column E has an event time, each person in the list takes up two to three rows, this is range 1. Columsn A through J where column C has a name and column E has an event time but THESE events can be up to 10 for EACH person. There may be a person in range 1 that does not exist in range 2 and there may be a person in range 2 that does not exist in range 1, but probalby 90% of them exist in both. I need to take the FIRST event time in range 1 and add it to a column BESIDE the FIRST event for range two, then take the LAST event in range 1 and put it beside the LAST event in range 2 ONLY, NO other event times matter. I need to compare the TWO times to see how many HH:MM:SS exist between the two times and put that out into ANOTHER column. I need to do this for each person that exists in Range 2, with all the data (two new columns) being added to range two's worksheet.....

    I know that is about as clear as mud, but it's the best I can describe it. To take a step back from it, I've got a list of names, dates and events and the time that the event occured, and a list of times those events were SUPPOSED to occur. I need to put them all on one spreadsheet for comparison to see how much out of adherence each person is.
    Attached Files Attached Files
    Last edited by Jasrenkai; 03-15-2011 at 01:09 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2003
    Location
    British Columbia , Canada
    MS-Off Ver
    03,07,10,13
    Posts
    727

    Re: Different sized range comparison

    Could you upload a sample of the sheet ?

  3. #3
    Registered User
    Join Date
    07-19-2010
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Different sized range comparison

    Two sheets, examples on sheets 1 and 2. Remember this is always a different number of people. I mean compared to the number of actual peoploe these examples really only have like .2% of the full scope of the comparison.

    I put it in my original post. Keep in mind: First time for first person in range 1 to the first time of the SAME person in range 2, last time of the first person in range 1 to the last time of the SAME person in range 2. DO for each PERSON in Range 2.

  4. #4
    Registered User
    Join Date
    07-19-2010
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Different sized range comparison

    Still working on this, any help would still be much appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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