Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
averaging
excel 2003
have long lists of data entry (column one days, column two week average), need to be able to drag down along column (B) rather than retype specific cells to average, problem comes in when dragging it will average 2:3 procedding average 1:2 A B 1 average 1:2 2 average 3:4 3 4 sounds simple but I cant figure it out, would greatly appreciate any help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
averaging
Use =AVERAGE(INDEX(A:A,ROW(A1)*2-1),INDEX(A:A,ROW(A1)*2))
and copy down the column If you data spans, for example, A5:A100, replace A:A by A5:A100 but leave A1 alone in the formula best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "fcs13" wrote in message ... excel 2003 have long lists of data entry (column one days, column two week average), need to be able to drag down along column (B) rather than retype specific cells to average, problem comes in when dragging it will average 2:3 procedding average 1:2 A B 1 average 1:2 2 average 3:4 3 4 sounds simple but I cant figure it out, would greatly appreciate any help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
averaging
minor detail, formula works great, right function, but i can't manipulate it
to average seven days from column a into column b then repeating, rather than two thanks for your time. "Bernard Liengme" wrote: Use =AVERAGE(INDEX(A:A,ROW(A1)*2-1),INDEX(A:A,ROW(A1)*2)) and copy down the column If you data spans, for example, A5:A100, replace A:A by A5:A100 but leave A1 alone in the formula best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "fcs13" wrote in message ... excel 2003 have long lists of data entry (column one days, column two week average), need to be able to drag down along column (B) rather than retype specific cells to average, problem comes in when dragging it will average 2:3 procedding average 1:2 A B 1 average 1:2 2 average 3:4 3 4 sounds simple but I cant figure it out, would greatly appreciate any help. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
averaging
=AVERAGE(INDEX(A:A,ROW(A1)*7-6),INDEX(A:A,ROW(A1)*7))
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "fcs13" wrote in message ... minor detail, formula works great, right function, but i can't manipulate it to average seven days from column a into column b then repeating, rather than two thanks for your time. "Bernard Liengme" wrote: Use =AVERAGE(INDEX(A:A,ROW(A1)*2-1),INDEX(A:A,ROW(A1)*2)) and copy down the column If you data spans, for example, A5:A100, replace A:A by A5:A100 but leave A1 alone in the formula best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "fcs13" wrote in message ... excel 2003 have long lists of data entry (column one days, column two week average), need to be able to drag down along column (B) rather than retype specific cells to average, problem comes in when dragging it will average 2:3 procedding average 1:2 A B 1 average 1:2 2 average 3:4 3 4 sounds simple but I cant figure it out, would greatly appreciate any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
averaging | Excel Discussion (Misc queries) | |||
Help with averaging... | Excel Discussion (Misc queries) | |||
Averaging | Excel Discussion (Misc queries) | |||
Averaging | Excel Discussion (Misc queries) | |||
Averaging in VB | Excel Programming |