Cell Location Series

Henry1807

New Member
Joined
Apr 22, 2002
Messages
21
Hey All,

Anyone know how to have cell locations increase (or decrease) automatically, in increments other than 1, in a series when you drag across?

For example: G10, G14, G18, G22, etc.

This works fine when you are increasing or decreasing in increments of 1 (G10, G11, G12, etc), but I can't quite get it to increase and decrease in other increments. It should be really easy, but I'm missing that lightbulb in the mind moment.

Thanks.

Henry
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

zacemmel

Well-known Member
Joined
Apr 29, 2002
Messages
636
=OFFSET($A$1,(COLUMN()-1)*2,0)

Or offset. Using that will increment it by 2's. This is assuming you are starting in column A.
 

Henry1807

New Member
Joined
Apr 22, 2002
Messages
21

ADVERTISEMENT

PaddyD,

I'm trying to create a table about 20 columns across, referencing data next to the table, with each cell in the table referencing data 9 rows below the cell above it.

So the cells would be:

G10, H10, I10, J10, ...
G19, H19, I19, J19, ...
G28, H28, I28, J28, ...

Etc, for a few hundred rows.

Thanks.

Henry
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
in general, you should be able to do this with a version of offset() (as zacemmel posted).

to provide a pecise answer, we'll need to know:

1) the range of cells where you're source data is

2) the range of cells where you want the results.

paddy
 

Watch MrExcel Video

Forum statistics

Threads
1,122,481
Messages
5,596,395
Members
414,063
Latest member
N_Bates

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top