How to fill series with a formula?

jake.peterson

Board Regular
Joined
May 22, 2012
Messages
68
I need to copy a formula and drag it down several thousand columns.

is there a way to make the formula change as you copy down the column like a fill series option?

for example, my formula is:
=ABS((AVERAGE($J$3:$O$3)-$O$3)/(AVERAGE($J$3:$O$3)))

But when I drag it to row 4 it remains the same formula for row 3.
Can I have this updated somehow without manually re-writing the formula a thousand times?
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Remove the $ signs before the row reference. They cause it to be absolute rather than relative when copying.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,554
Messages
5,487,527
Members
407,604
Latest member
sama9000

This Week's Hot Topics

Top