Formula to autofill with an evenly spaced increment of rows?

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Relative reference autofill increment other than +1 3
Formula autofill to cells below – formula arguments are cell areas in different columns 1
Autofill column values in formulas 4
Formula Content linked to other cells formula Content 5
Copying cell formulas 1
referring to formula in a non active cell from active cell 1
Alpha sorting (with a twist...?) 3
Extracting numbers from text 5

Top