I have a set of 9,999 equi-spaced data points, and I would like to calculate the autocorrelations for ALL lags up to 5,000. In Excel, I want to have this code: =CORREL(B1:B9998,B2:B9999) =CORREL(B1:B9997,B3:B9999) =CORREL(B1:B9996,B4:B9999) ... =CORREL(B1:B5000,B5000:B9999) Unfortunately, the formula does not "translate" nicely when I extend it downwards. Also I have Excel 2008 for Mac, which does not handle VB Macros. Can anyone direct me? Or suggest a better way of doing it? I don't have MatLab, but I do have Mathematica. Thanks in advance.