Remember Me?

#1
January 9th 09, 10:23 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jan 2009 Posts: 1
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
January 9th 09, 10:32 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Oct 2008 Posts: 1,805
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
January 10th 09, 03:09 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 15,768
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\$11)*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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post smaruzzi Excel Discussion (Misc queries) 2 May 21st 07 07:27 PM whitepa05 Excel Worksheet Functions 1 April 19th 07 10:30 PM Larry Excel Worksheet Functions 0 July 14th 06 09:19 PM ers Charts and Charting in Excel 0 March 1st 06 01:05 AM Gerrym Excel Worksheet Functions 2 November 16th 04 04:03 PM

All times are GMT +1. The time now is 04:46 AM.