Quote:
Originally Posted by wickedchew
No need to use a macro in this one. You can use the formula:
=AVERAGE(OFFSET('Raw Data (I&R)'!$B$2,0,0,COUNTA('Raw Data (I&R)'!$B:$B)-1,1))
The formula will adjust the range automatically.
|
I really appreciate your response Wickedchew as it does work. However, it's averaging the entire column of data, and I would like it to average the past 30 days of data and shift everyday. Is this possible? Thanks again!