+ Reply to Thread
Results 1 to 2 of 2

Match and sort times between two columns

  1. #1
    Registered User
    Join Date
    08-21-2012
    Location
    Houston
    MS-Off Ver
    Excel 2007
    Posts
    1

    Match and sort times between two columns

    I have a spreadsheet (see below for actual data) with ~95,000 entries and I am trying to match and sort the data by time (column's B and E). There are missing times in column B, so I want to match up the times in column E to column B and delete the entries that don't match. I have tried several attempts with using the "vlookup" function, but I guess I don't understand how it works.



    A B C D E F

    8/16/2012 3:49:25 33857 8/16/2012 3:49:25 122
    8/16/2012 3:49:35 32865 8/16/2012 3:49:35 122
    8/16/2012 3:50:05 33278 8/16/2012 3:49:45 137
    8/16/2012 3:50:15 33113 8/16/2012 3:49:55 127
    8/16/2012 3:50:25 33196 8/16/2012 3:50:05 127
    8/16/2012 3:50:35 33196 8/16/2012 3:50:15 124
    8/16/2012 3:50:55 32810 8/16/2012 3:50:25 122
    8/16/2012 3:51:05 32672 8/16/2012 3:50:35 116
    8/16/2012 3:51:15 32507 8/16/2012 3:50:45 150
    8/16/2012 3:51:25 32507 8/16/2012 3:50:55 112
    8/16/2012 3:51:35 33030 8/16/2012 3:51:05 108
    8/16/2012 3:51:45 33609 8/16/2012 3:51:15 122

    Any help would be appreciated!!

    Thanks
    Last edited by finkle00; 08-21-2012 at 04:01 PM.

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Match and sort times between two columns

    Does this work for you? I assume the date remains the same across your 95000 lines
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ 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