How can I get Excel to increment ranges arguments by more than one row when I fill down a formula?
For example, if I want Excel to keep averaging the next five numbers in a column, how do I set the average function to keep it in a pattern throughout, without changing it from an increment of one from the first and last number of the previous formula?
Excel keeps giving me this when I fill down:
=Average(A1:A5) =Average(A2:A6) =Average(A3:A7)
I want Excel to do this instead:
=Average(A1:A5) =Average(A6:A10) =Average(A11:A15)
How can I do this by filling down?