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.
|