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
Bookmarks