I have isolated a large number of sets of 42 to 84 numbers arranged in columns. I want to write a (loop? code? equation?) that will place the previous average adjacent to the next cell. This means if my numbers going downwards read 20,40,40,80,20 then the adjacent column would read -- , 20 , 30 , 33.3 , 45. These numbers represent the average of all the numbers in the original column that come before this row. How can this be done? Thanks
EDIT: Problem solved