I was wondering if you could assist me in setting up a moving average for some data points that I have in excel.



age d18O
0.00 3.11
0.00 2.88
0.02 3.41
0.05 3.17
0.09 3.27
0.12 3.32
0.27 3.03
0.36 3.31
0.49 3.14
0.50 3.75
0.60 3.42
0.83 3.03
0.84 3.47
0.91 3.04
0.92 2.91
0.98 3.64
0.99 3.44

I have values like these all the way to about 5300, and I would like to get an average d18O value for all the values between 0.00-0.99. I have used this formula: =AVERAGEIFS(B:B,A:A,">=0.0",A:A,"<=0.99"). But, I have no idea how to make excel continue to follow through the series (take an average from 1-1.99, 2-2.99….) without typing it in manually.

Please let me know if you can help me figure this out.

Justin