If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 dynamic cell number
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

dynamic cell number

#1
January 9th 09, 10:23 PM posted to microsoft.public.excel.worksheet.functions
 Dr. S[_2_] external usenet poster 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
 Sheeloo[_3_] external usenet poster 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
 T. Valko external usenet poster 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.

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post Dynamic number formatting smaruzzi Excel Discussion (Misc queries) 2 May 21st 07 07:27 PM dynamic number format whitepa05 Excel Worksheet Functions 1 April 19th 07 10:30 PM NUMBER OF ROWS IN A DYNAMIC RANGE Larry Excel Worksheet Functions 0 July 14th 06 09:19 PM Help with copying dynamic column selected based on remote cell value and dynamic formula fill ers Charts and Charting in Excel 0 March 1st 06 01:05 AM Dynamic number of ROWS Gerrym Excel Worksheet Functions 2 November 16th 04 04:03 PM

All times are GMT +1. The time now is 09:41 AM.