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

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