skipping columns

1. skipping columns

I realize this has been posted before, but I can't seem to find it. Suppose
I have data in columns E, L, S,etc., in other words, ever 7th column. My row
range is 3:650. How can I average these columns in adjacent cells, i.e. the
average of E3:E650 in A700, the average of L3:L650 in B700, and so on? I
know it has something to do with INDIRECT and OFFSET, but can't seem to make
heads or tails out of it. In addition, will this kind of manipulation work
with array formulae?

Wazooli

2. Re: skipping columns

On cell A700 type
=AVERAGE(OFFSET(\$E\$3,0,COLUMN()*7-7,648))
aand copy it across B700 and so on

"Wazooli" <Wazooli@discussions.microsoft.com> wrote in message
news:1C131F98-CB1C-4D99-8F5E-AC633E3759F7@microsoft.com...
>I realize this has been posted before, but I can't seem to find it.
>Suppose
> I have data in columns E, L, S,etc., in other words, ever 7th column. My
> row
> range is 3:650. How can I average these columns in adjacent cells, i.e.
> the
> average of E3:E650 in A700, the average of L3:L650 in B700, and so on? I
> know it has something to do with INDIRECT and OFFSET, but can't seem to
> make
> heads or tails out of it. In addition, will this kind of manipulation
> work
> with array formulae?
>
> Wazooli

3. Re: skipping columns

Thanks - I'll try that

wazooli

"N Harkawat" wrote:

> On cell A700 type
> =AVERAGE(OFFSET(\$E\$3,0,COLUMN()*7-7,648))
> aand copy it across B700 and so on
>
> "Wazooli" <Wazooli@discussions.microsoft.com> wrote in message
> news:1C131F98-CB1C-4D99-8F5E-AC633E3759F7@microsoft.com...
> >I realize this has been posted before, but I can't seem to find it.
> >Suppose
> > I have data in columns E, L, S,etc., in other words, ever 7th column. My
> > row
> > range is 3:650. How can I average these columns in adjacent cells, i.e.
> > the
> > average of E3:E650 in A700, the average of L3:L650 in B700, and so on? I
> > know it has something to do with INDIRECT and OFFSET, but can't seem to
> > make
> > heads or tails out of it. In addition, will this kind of manipulation
> > work
> > with array formulae?
> >
> > Wazooli

>
>
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1