Fill down while skipping cells

  • Thread starter Thread starter tpl
  • Start date Start date
T

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!
 
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
 
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
 
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
 
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
 
Back
Top