Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old 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
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.

  #2   Report Post  
Old 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
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   Report Post  
Old 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
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.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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 04:46 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017