Here's what I've got:
2 sets of data stored on 2 machines, both in excel.
set 1 stores data 4 times a minute :00, :15, :30 and :45
set 2 stores data ~ 4 times a minute, however it could be 14 seconds it could be 16 or 17.

I'm trying to get the data to match up so I can put one against the other. I have over 22,000 rows so manual doesn't make sense. I can't just match them up since they end up being several hundred rows off by the time you get to 22000 rows. I was thinking converting the dates to integers the maybe rounding off to the nearest 15 seconds. May there be some way to do an IF statement that if seconds >50 or <=5 then seconds =0, and so on...

example from set 1
Date/time x1 x2 x3
10/9/2008 12:40:05 55.449 52.041 100.024
10/9/2008 12:40:21 55.159 51.809 99.948
10/9/2008 12:40:37 55.322 51.07 99.881
10/9/2008 12:40:54 55.77 48.915 99.494
10/9/2008 12:41:09 56.364 45.709 100.134
10/9/2008 12:41:26 56.332 49.614 100.444
10/9/2008 12:41:43 55.387 52.631 100.136
10/9/2008 12:41:59 55.208 52.817 99.945
10/9/2008 12:42:15 55.357 51.681 99.817
10/9/2008 12:42:31 55.52 49.916 99.841
10/9/2008 12:42:47 55.749 49.234 100.002
10/9/2008 12:43:03 55.969 49.591 100.08
10/9/2008 12:43:19 55.717 50.446 100.091
10/9/2008 12:43:36 55.945 49.633 99.685
10/9/2008 12:43:52 56.191 45.086 99.301
10/9/2008 12:44:08 56.676 38.372 99.709

Example from set 2:
Date/time y1
10/9/08 12:40:00 520.8542
10/9/08 12:40:15 566.1864
10/9/08 12:40:30 566.3815
10/9/08 12:40:45 552.2681
10/9/08 12:41:00 476.7576
10/9/08 12:41:15 471.7821
10/9/08 12:41:30 466.8066
10/9/08 12:41:45 466.8066
10/9/08 12:42:00 635.4413
10/9/08 12:42:15 642.4959
10/9/08 12:42:30 503.4051
10/9/08 12:42:45 437.1098
10/9/08 12:43:00 438.2805
10/9/08 12:43:15 525.1467
10/9/08 12:43:30 700.7524
10/9/08 12:43:45 820.1643
10/9/08 12:44:00 895.3430
10/9/08 12:44:15 929.6641

10/21/2008 4:35:15 PM

14

10/21/2008 5:09:26 PM

take a look a the following file.
I created a "Rounded Time" column, that takes the Set 1 date and rounds it to date/time on 15 second intervals. Then it uses the Rounded Time column to do a lookup on the date in Set 2. If the exact date/time is not found, in Set 2, it leaves a blank. If you can hide the Rounded Time column if you don't want it visible.
http://joelion.com/temp/DateLookup.xls

[Edited on October 21, 2008 at 10:37 PM. Reason : .]

10/21/2008 10:36:38 PM

Is all of that data on each row in one cell?

10/22/2008 7:01:54 AM

^^Awesome
Thanks a lot

10/22/2008 10:09:23 AM