Auto fill

**duongthaiha** · 10-08-2010, 07:25 AM

Hi

I have a cell A1= AVERAGE(D1:D100) how can i auto fill the A2 to be A2=AVERAGE(D101:D200) and A3=AVERAGE(D201:300)

Thanks a lot

**DonkeyOte** · 10-08-2010, 07:45 AM

You can use either:

A1
=AVERAGE(INDEX(D:D,1+100*(ROWS(A$1:A1)-1)):INDEX(D:D,100*ROWS(A$1:A1)))

or

A1
=AVERAGE(OFFSET($D$1:$D$100,100*(ROWS(A$1:A1)-1),0))

the latter though shorter in syntax terms is volatile (see link in sig. for more info. if interested)

**duongthaiha** · 10-08-2010, 07:52 AM

Hi
Thanks a lot for that

Is there a way to used the auto fill step value in excel 2010?

Best regards

Originally Posted by DonkeyOte

You can use either:

A1
=AVERAGE(INDEX(D:D,1+100*(ROWS(A$1:A1)-1)):INDEX(D:D,100*ROWS(A$1:A1)))

or

A1
=AVERAGE(OFFSET($D$1:$D$100,100*(ROWS(A$1:A1)-1),0))

the latter though shorter in syntax terms is volatile (see link in sig. for more info. if interested)

**DonkeyOte** · 10-08-2010, 07:57 AM

No - Fill Series relates to Constants.

(please don't quote entire posts in your reply - clutters your thread and board in general)

**duongthaiha** · 10-08-2010, 07:57 AM

Really appreciate your help. Its a great:D

Re: Auto fill