Home |
Search |
Today's Posts |
#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
|
|||
|
|||
On cell A700 type
=AVERAGE(OFFSET($E$3,0,COLUMN()*7-7,648)) aand copy it across B700 and so on "Wazooli" wrote in message ... 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
|
|||
|
|||
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Skipping and protected cells | Excel Discussion (Misc queries) | |||
Auto Skipping and Protecting Worksheet | New Users to Excel | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) |