Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dynamic cell number
copying and pasting a function down a column will increase the cell number by
one in each row (example =A1+6, and below: =A2+6 and below =A3+6 etc.) Is it possible to make that calculation for every 4th row and list the results directly in a column. Or asked differently is ther any way to increase the cell number by a different value, by 4 for instance? (=A1+6 will be followed by =A5+6 and then =A9+6. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dynamic cell number
One way is to enter this in row 1 (in any col other than A) and copy down
=INDIRECT("A" & (ROW()*4-3))-6 "Dr. S" wrote: copying and pasting a function down a column will increase the cell number by one in each row (example =A1+6, and below: =A2+6 and below =A3+6 etc.) Is it possible to make that calculation for every 4th row and list the results directly in a column. Or asked differently is ther any way to increase the cell number by a different value, by 4 for instance? (=A1+6 will be followed by =A5+6 and then =A9+6. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dynamic cell number
Here's a non-volatile method.
Assume you want the results to appear starting in cell D1. Enter this formula in D1 an copy down as needed: =INDEX(A:A,ROWS(D$1:D1)*4-3)+6 -- Biff Microsoft Excel MVP "Dr. S" wrote in message ... copying and pasting a function down a column will increase the cell number by one in each row (example =A1+6, and below: =A2+6 and below =A3+6 etc.) Is it possible to make that calculation for every 4th row and list the results directly in a column. Or asked differently is ther any way to increase the cell number by a different value, by 4 for instance? (=A1+6 will be followed by =A5+6 and then =A9+6. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic number formatting | Excel Discussion (Misc queries) | |||
dynamic number format | Excel Worksheet Functions | |||
NUMBER OF ROWS IN A DYNAMIC RANGE | Excel Worksheet Functions | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
Dynamic number of ROWS | Excel Worksheet Functions |