match two columns (with equal dates) and their attached datasets
 

I do have several instruments that collect water quality data every 15
minutes. All data sets are imported into excel. Because I do have to throw
out some data points, there are gaps in the data sets and the date column of
the instruments do not line up anymore. In order to do appropriate statistics
I do have to have matching date columns.
how can I do this?

thanks

match two columns (with equal dates) and their attached data
 

hi claudia,

you are relying on the structure of the dataset to align the time
series from the various instruments, so that any interruption ruins
the alignment.

i suggest an alternative:

since each data point, ie row of data collected, is probably time
stamped with a time, your statistics functions should exploit the
time stamp. even if the rows are out of alignment, the timestamps
should identify the points for each time. that's easily done using
VLOOKUP.

------------------------------------------------------------------------
ExcelJockey's profile: http://www.exceljockeys.com/forums/p...iewprofile&u=4
View this thread: http://www.exceljockeys.com/forums/v...c.php?t=304597