Auto Fill - cell numbering patterns

[Guest]

When an auto fill is applied to three cell containing the entries:

=Sheet1!C303, =Sheet1!C318, =Sheet1!C333,

Noting that the intended pattern is a simple linear pattern, increasing row
number by 15 each time.

These are the resulting auto fill entries:

=Sheet1!C303, =Sheet1!C318, =Sheet1!C333, =Sheet1!C306, =Sheet1!C321,
=Sheet1!C336.

How do I get the auto fill function to follow the obvious “previous row
number +15†pattern?


Thanks,
Chris

 

[Guest]

try:

=INDIRECT("Sheet1!C"& (ROW()-ROW($A$1))*15+30)

assuming you start in row 1. Change $A$1 to starting row.

 

[Bernard Liengme]

Try =INDIRECT("Sheet1!C"&303+(ROW(A1)-1)*15) in first cell, then drag down
column to copy
best wishes

 

[Paul Hyett]

In microsoft.public.excel.misc on Wed, 8 Aug 2007, Toppers

try:

=INDIRECT("Sheet1!C"& (ROW()-ROW($A$1))*15+30)

assuming you start in row 1. Change $A$1 to starting row.

'Indirect' - yet another function I've never heard of!