How do I get excel to drag cell references, A3,A6...A9?

BRADX · May 15th, 2002, 07:05 AM

Good day
I was wondering if anyone knows how I can drag cell references so the series continues. Here's what I mean: I would like the first cell to =A3, then the next to go up by cell cells and be =A6....then A9, when I drag the cells with A3, and A6 references, it just repeats that pattern A3,A6,A3,A6...but I would like it to drag to go to A3, A6, A9, A12. Does anyone know a solution to this?
Thanks.

Mudface · May 15th, 2002, 07:14 AM

Take a look here, might help you out :-

http://www.mrexcel.com/board/viewtop...8315&forum=2&1

BRADX · May 15th, 2002, 07:47 AM

Thanks,
But for some reason that formula gives me an errror, I'm not sure how the formula separates the rows and columns

Mudface · May 15th, 2002, 08:07 AM

In your case the formula would be: -

=INDIRECT("A" & 3+(ROW()-1)*3)

Copy this into your first cell (say B1) and autofill down. If you're starting off in a different cell, use the cell row no instead of the -1 above (eg if you're starting in cell B9, use: - =INDIRECT("A" & 3+(ROW()-9)*3) in your first cell). HTH.

BRADX · May 15th, 2002, 08:37 AM

Thanks a lot!

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

May 15th, 2002, 07:05 AM	#1
BRADX New Member Join Date: May 2002 Posts: 8	Good day I was wondering if anyone knows how I can drag cell references so the series continues. Here's what I mean: I would like the first cell to =A3, then the next to go up by cell cells and be =A6....then A9, when I drag the cells with A3, and A6 references, it just repeats that pattern A3,A6,A3,A6...but I would like it to drag to go to A3, A6, A9, A12. Does anyone know a solution to this? Thanks.

May 15th, 2002, 07:14 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Take a look here, might help you out :- http://www.mrexcel.com/board/viewtop...8315&forum=2&1

May 15th, 2002, 07:47 AM	#3
BRADX New Member Join Date: May 2002 Posts: 8	Thanks, But for some reason that formula gives me an errror, I'm not sure how the formula separates the rows and columns

May 15th, 2002, 08:07 AM	#4
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	In your case the formula would be: - =INDIRECT("A" & 3+(ROW()-1)3) Copy this into your first cell (say B1) and autofill down. If you're starting off in a different cell, use the cell row no instead of the -1 above (eg if you're starting in cell B9, use: - =INDIRECT("A" & 3+(ROW()-9)3) in your first cell). HTH.

May 15th, 2002, 08:37 AM	#5
BRADX New Member Join Date: May 2002 Posts: 8	Thanks a lot!