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