I have two sets of data and I am trying to see if there is a correlation between the two. The Correl feature works great! but only if the data is exactly on top of it. I was wondering if there is a formula that would work out if there is a correlation even if there is a lag between the two.. i.e it would know that there is a correlation on the data below and the lag between the two:

01:00 02:00 03:00 04:00 05:00 06:00 07:00 08:00 09:00 10:00 11:00 12:00
1 2 3 4 5 6 7 6 5 4 3 2
5 6 7 6 5 4 3 2 1 1 1 1

Thanks very much for your help in advance and please feel free to tell me that this can't be done.

Many thanks,