Formula to autofill with an evenly spaced increment of rows?
 

Hi,

Could one of your Excel gurus please let me know how to write a formula to
autofill cells in a row from an average of two cells in a row, i.e., B1:B2,
B3:B4, B5:6... to A1, A2, A3...?

Thanks,
FormulaChalenged

Hi!

Try this in A1:

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

Copy down as needed.

Biff

"FormulaChallenged" wrote in
message ...
Hi,

Could one of your Excel gurus please let me know how to write a formula to
autofill cells in a row from an average of two cells in a row, i.e.,
B1:B2,
B3:B4, B5:6... to A1, A2, A3...?

Thanks,
FormulaChalenged