| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
drag formula down with other reference
Is it possible to drag a formula in that way that the result is not a
successive cell number example cell A1 contains formula "=stdev(a2:a7) cell a2 contains formula "=stdev(a8:a13) Is it possible to drag the formula down so that cell a3 contains "=stdev(a14:19) and cell a4 contains "=stdev(a20:a25) and so on for cells a5, a6, a7 etc. etc. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rang reference incrementing by more than one on formula drag | Excel Worksheet Functions | |||
| when I drag a formula to other cells the reference is the same | Excel Worksheet Functions | |||
| Lock cell reference in formula, even when moved with click & drag | Excel Worksheet Functions | |||
| Help.. Drag reference to the right does not work... | New Users to Excel | |||
| Using Index to Transpose, Update Reference Cells as you Drag Down | Excel Worksheet Functions | |||
Threaded Mode
