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
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,669
Messages
5,838,682
Members
430,563
Latest member
Raeyven

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