ExcelBanter - Absolute question when autofilling

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Absolute question when autofilling (https://www.excelbanter.com/excel-discussion-misc-queries/71816-absolute-question-when-autofilling.html)

Danielle

Absolute question when autofilling

I have a formula:
=AVERAGE(Sheet1!K$4:K$34)

I am trying to drag down on the worksheet (no across)... so the formula will
be:

=average(sheet1!L$4:L$34)
=average(sheet!M$4:M$34)
and so on...when I drag the formula down the column.

Dave Peterson

Absolute question when autofilling

Try dragging across to get as many as you need.

Then select them
edit|copy
select where you really want the formulas to be
edit|paste special|check transpose.

Danielle wrote:

I have a formula:
=AVERAGE(Sheet1!K$4:K$34)

I am trying to drag down on the worksheet (no across)... so the formula will
be:

=average(sheet1!L$4:L$34)
=average(sheet!M$4:M$34)
and so on...when I drag the formula down the column.

--

Dave Peterson

Danielle

Absolute question when autofilling

Brilliant! Thanks - didn't even think about that.

"Dave Peterson" wrote:

Try dragging across to get as many as you need.

Then select them
edit|copy
select where you really want the formulas to be
edit|paste special|check transpose.

Danielle wrote:

I have a formula:
=AVERAGE(Sheet1!K$4:K$34)

I am trying to drag down on the worksheet (no across)... so the formula will
be:

=average(sheet1!L$4:L$34)
=average(sheet!M$4:M$34)
and so on...when I drag the formula down the column.

--

Dave Peterson

All times are GMT +1. The time now is 06:51 PM.