Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
repeating function q
I have a column of data where I need to select a group of X number of cells
each time and obtain an average. When I copy the formula down it only copies the formula with one additional space down, but I want it to jump over the cells that have already been averaged. Example formuala is: Average(B1:B5), when copied down it goes (B2:B6), but I want (B6:10). Im sure this is easy but I dont know the shortcut. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repeating Above Value | Excel Worksheet Functions | |||
Repeating a concatenate function | Excel Worksheet Functions | |||
repeating months | Excel Worksheet Functions | |||
repeating a row at top of page | Excel Discussion (Misc queries) | |||
Repeating | Excel Worksheet Functions |