Hello All,
I have a series of data that is arranged monthly from 2005 to present. I am trying to show year over year trends for the data set. Thus, I am trying to divide January 2006 by January 2005, and then January 2007 by January 2006 etc. etc. However, I can't use the autofill equation because I have to skip 11 cells between each iteration of the equation (the monthly information). Is there anyway that I can modify the autofill function, or create an equation, that will allow me to skip those 11 cells in between?
Thanks a TONNE!
