Autofill for cells in a certain pattern

[etizzle]

Dear Mr-Excel Community

I have been using excel for a while but i can hardly call myself a pro,

Anyways i would like to autofill a few cells which are in a pattern based on data in differant cells,
here is an example of the code that i am using

for cell g5 i entered =c0
for cell g6 i entered =c33
for cell g7 i entered =c65

The data that needs to go into the g column is in increments of 32
i was wondering if there was an easier way to do this using a formula/autofill as excel wont recognize this pattern,

Thanks in advance,
Ethan


I have to do this hundreds of times,

 

[footoo]

C0 to C33 is not an increment of 32.

If you select G6:G7 and drag down it should increment as required.

 

[AliGW]

0-33 is not an increment of 32 ...

 

[etizzle]

thanks footoo for your reply
when i do as instructed"select g6:g7" and drag down g8 shows data from c66 not c97 like it should

 

[AliGW]

That's because there is no pattern for Excel to recognise. You need this:

G6=0
G7=32
G8=64

Now select the three cells and drag down - Excel now understands what you want.

Or this:

G6=1
G7=33
G8=65

 

[etizzle]

hi Aligw

the pattern is from the next cell, so g7 will need to equal c65, g8 will need to equal c97,g9 will need to equal data from c129 ect ect
i have tried selecting 3 cells which use that pattern and dragging them down to no avail,

 

[AliGW]

I don't think you are understanding. Look:

0-33 = 33
33-65 = 32

These are not equal increments, so there is no pattern of 32 increments for Excel to understand. The only way you can get what you want is to start with 1 in G6, as I showed you above.

 

[footoo]

thanks footoo for your reply
when i do as instructed"select g6:g7" and drag down g8 shows data from c66 not c97 like it should

If you have (like in your original post) :
G6 - C33
G7 - C65
then selecting G6:G7 and dragging down will increment in steps of 32.

 

[snjpverma]

hi Aligw

the pattern is from the next cell, so g7 will need to equal c65, g8 will need to equal c97,g9 will need to equal data from c129 ect ect
i have tried selecting 3 cells which use that pattern and dragging them down to no avail,

IF you have C65 in G7 and C97 in G8, then you can select G7 and G8 and then drag down. You will get the desired result

 

[AliGW]

Here's what I get:

Excel 2016 (Windows) 32 bit
	I	J
2	0	1
3	32	33
4	64	65
5	96	97
6	128	129
7	160	161
8	192	193
9	224	225
10	256	257
11	288	289
Sheet1

As the others have noted, if you want the first increment of 33 between 0 and 33, then select G7 and G8 only when you drag down.