Continue a series: B2, B14, B26?

BRADX · May 14th, 2002, 01:43 PM

Hi everyone
I would like a series to continue which refers to cells but goes up by 12 cells each time(by a year). I am referencing these cells B2, B14 in a column and would like just to put the value in every 12 cells in a row and drag this formula to get 50 years worth. If anyone knows why excel want let the pattern continue by referring to cells going up by 12 could you let me know
Thanks Jeff

Mudface · May 14th, 2002, 01:49 PM

The following might work OK for you, if your first cell is in row 1 of your sheet use the following formula and drag down to autofill: -

=INDIRECT("B" & 2+(ROW()-1)*12)

Adjust the amount subtracted above to reflect the starting row of where you enter your formula (ie if you start in row 15, use a -15 rather than -1 in the above formula).

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 14th, 2002, 01:43 PM	#1
BRADX New Member Join Date: May 2002 Posts: 8	Hi everyone I would like a series to continue which refers to cells but goes up by 12 cells each time(by a year). I am referencing these cells B2, B14 in a column and would like just to put the value in every 12 cells in a row and drag this formula to get 50 years worth. If anyone knows why excel want let the pattern continue by referring to cells going up by 12 could you let me know Thanks Jeff

May 14th, 2002, 01:49 PM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	The following might work OK for you, if your first cell is in row 1 of your sheet use the following formula and drag down to autofill: - =INDIRECT("B" & 2+(ROW()-1)*12) Adjust the amount subtracted above to reflect the starting row of where you enter your formula (ie if you start in row 15, use a -15 rather than -1 in the above formula).