I have 2 data columns, both are matched timed series, each point has a gap of
5 hours. Somebody else managed to make excel correlate the raw data and said
that they was a lag within the data point, he then set about lagging the data
by one day and then said that the lag might be as much as 5 hours, and that I
should make excel recognise this....How????