A Microsoft Excel forum. ExcelBanter

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.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

dynamic cell number



 
 
Thread Tools Display Modes
  #1  
Old January 9th 09, 11:23 PM posted to microsoft.public.excel.worksheet.functions
Dr. S[_2_]
external usenet poster
 
Posts: 1
Default 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.
Ads
  #2  
Old January 9th 09, 11:32 PM posted to microsoft.public.excel.worksheet.functions
Sheeloo[_3_]
external usenet poster
 
Posts: 1,805
Default 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  
Old January 10th 09, 04:09 AM posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
 
Posts: 15,768
Default 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

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

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 02:05 AM
Dynamic number of ROWS Gerrym Excel Worksheet Functions 2 November 16th 04 05:03 PM


All times are GMT +1. The time now is 06:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.