Gentlemen,
I'd like to make a moving average which is increasing per cell.
I want it to be like this for a complete column:
=average(A1:A1)
=average(A1:A2)
=average(A1:A3)
=average(A1:A4)
..
..
=average(A1:A2000)
Since the list is pretty long I can't change it manually and autofill makes the A1 cell move everytime so it's not static. Do you guys know a trick to solve my problem?
Thanks,
Last edited by sylvesteralone; 08-30-2011 at 02:01 PM.
The $ in a formula will anchor a column or row so that it doesn't change when you copy or drag it.
Try (in A1)
=average($A$1:A1)
copied down.
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Outstanding! That sir saved me a lot of trouble. Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks