Hello Everyone
I am trying to get the 12 weeks of rolling average in the attached file. can any one suggest any function which helps doing it. Attached is the sample
Thanks
Hello Everyone
I am trying to get the 12 weeks of rolling average in the attached file. can any one suggest any function which helps doing it. Attached is the sample
Thanks
A 12 week rolling average of what? You've highlighted one cell. What do you expect the result to be in that highlighted cell?
You could use:for the first line.Formula:Please Login or Register to view this content.
Then drag down. Is that what you are looking for? There can't be any gaps.
Regards, TMS
Last edited by TMS; 02-18-2014 at 05:28 AM. Reason: Edit formula
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks