Auto Fill - cell numbering patterns
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 |
Auto Fill - cell numbering patterns
try:
=INDIRECT("Sheet1!C"& (ROW()-ROW($A$1))*15+30) assuming you start in row 1. Change $A$1 to starting row. "Kiwi Chris" wrote: 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 |
Auto Fill - cell numbering patterns
Try =INDIRECT("Sheet1!C"&303+(ROW(A1)-1)*15) in first cell, then drag down
column to copy best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Kiwi Chris" <Kiwi wrote in message ... 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 |
Auto Fill - cell numbering patterns
In microsoft.public.excel.misc on Wed, 8 Aug 2007, Toppers
wrote : 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! :) -- Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me) |
All times are GMT +1. The time now is 02:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com