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


Replace @mailinator.com with @tiscali.co.uk


"tpl" wrote in message
...

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!




--
tpl

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

On Mon, 10 Dec 2007 17:41:55 +0000, tpl wrote:


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!

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

On Tue, 11 Dec 2007 19:05:04 +0000, tpl wrote:


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;597646 Wrote:
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

On Mon, 10 Dec 2007 17:41:55 +0000, tpl
wrote:
-

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