Fill options

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gio64@officeformac.com - 20 Sep 2008 21:15 GMT

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have the following problem:
I have a section of my spreadsheet where I have sets of 3 values for which I need to write the average.
I have the average value in another area of the sheet. I have all the average values lined up in one row, one after the other.
If I write the average formula for the first set of 3 values and then I do a fill right, instead of putting in the second cell the average of the second set of 3 values, it places the average of the second, third and fourth values. Is there any way to have the fill command fill "skipping"3?
Thank you

Reply to this Message

JE McGimpsey - 26 Sep 2008 05:20 GMT

> Version: 2008
> Operating System: Mac OS X 10.5 (Leopard)
[quoted text clipped - 9 lines]
> set of 3 values, it places the average of the second, third and fourth
> values. Is there any way to have the fill command fill "skipping"3?

If I understand you correctly, you have something like:

A B C D E F G H I
1 10 2 5 7 3 9 11 6 8

and you want the results to be

AA AB AC
100 5.666666667 6.333333333 8.333333333

If so, then one way:

AA100: =AVERAGE(OFFSET($A$1,0,3*(COLUMN()-COLUMN($AA$100)),1,3))

which you can then fill right.

Reply to this Message

Mac Forum / Applications / Excel / September 2008

Fill options