Fill down while skipping cells

[tpl]

I have a long list of data listed as duplicate data points that need to
be averaged. For example, A1 and A2 are duplicates that need to be
averaged, A3 and A4 are duplicates that need to be averaged, etc. How
can I create an AVERAGE function and then fill it down so that it will
add 2 cells each time (as in =AVERAGE(A1+2),(A2+2) but this does not
work)? Thanks!

 

[Sandy Mann]

I don't really follow your post but if youm are asking hot to put the
formula in every second cell then in B1 enter your formula:

AVERAGE(A1+2),(A2+2)

leave B2 blank then highlight both B1& B2 and drag down on the fill handle.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Gord Dibben]

In B1 enter =AVERAGE(OFFSET($A$1,ROW()*2-2,0,2,1))

Drag/copy down until you get #DIV/0!


Gord Dibben MS Excel MVP

 

[tpl]

Thank you Gord! I was able to use the formula you provided and it was
beautiful. However, I was unable to change it so that I could move the
AVERAGE(OFFSET) formula to a cell other than B1 and still have the
reference range for the averages stay the same. Is there another trick
to this?

Thanks so much,

Tanya

 

[Gord Dibben]

Keeping the same reference range but placing the formula into a cell other than
B1.

=AVERAGE(OFFSET($A$1,ROW(1:1)*2-2,0,2,1))


Gord