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,

 

[etizzle]

thanks for your replies,
sadly though this is not working,
i do understand that the first cell is in increments of 33 but the rest of the cells are not, they are in the 32 increment

when i select 3 cells that use the 32 increment and drag down i dont get the increment,

is there a way that i can upload an excel file to the community to show this?

Kindest Regards,
Ethan

 

[AliGW]

No, you can't here, sorry, but you could use a file-sharing site such as DropBox, which some of us would be prepared to access. Which version of Excel are you using, by the way?

 

[footoo]

thanks for your replies,
sadly though this is not working,
i do understand that the first cell is in increments of 33 but the rest of the cells are not, they are in the 32 increment

when i select 3 cells that use the 32 increment and drag down i dont get the increment,

is there a way that i can upload an excel file to the community to show this?

Kindest Regards,
Ethan

Why not just select 2 cells like everyone has suggested from post #2 onwards ?

 

[AliGW]

@Footoo - because the OP says it's not working for him. I have suggested he provide a file.

@Ethan - without seeing that file, how can we help? And please let us know which version of Excel you are using. Thanks!

 

[etizzle]

thanks for the advice,
i received a notification saying that you messaged me ali but it said that my imbox was full for some reason(i have just registered and activated my account)
so i have still not received your message
i am using 2007 32 bit,

 

[AliGW]

OK. Here's what I said in response to your PM:

"Please keep the discussion in your thread, where I have explained how to provide a file".

See posts #12 and #14 above.

 

[etizzle]

thanks Ali for your reply
heres a link showing a basic version of what i am trying to say with excel not recognizing the relationship with the autofill feature

https://www.dropbox.com/s/pt5tr2tmmybvctn/Test to prove my point.xlsx?dl=0

Thanks in advance

 

[AliGW]

WHICH VERSION OF EXCEL ARE YOU USING, please?

How does this, from your file, relate to the query you have posted in this thread?

Excel 2016 (Windows) 32 bit
	E	F	G	H	I
3		it is meant to show "1,2,3,4,5,6" here
4	1	1
5		2
6	2	2
7		3
8	3	3
9		4
10	4	4
11		5
12	5	5
13		6
14	6	6
Sheet1

Cell Formulas
Range	Formula
F4	=E4

 

[etizzle]

WHICH VERSION OF EXCEL ARE YOU USING, please?

How does this, from your file, relate to the query you have posted in this thread?

Excel 2016 (Windows) 32 bit

	E	F	G	H	I
it is meant to show "1,2,3,4,5,6" here

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]3[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: right"][/TD]
[TD="align: right"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="align: right"][/TD]
[TD="align: right"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]
[TD="align: right"][/TD]
[TD="align: right"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F4[/TH]
[TD="align: left"]=E4[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Hi Ali thanks for your reply...
this is a little hard to explain but i will try my best

what i am trying to achieve in the f column is 1,2,3,4,5,6 going downwards
i know that i can do this manually by saying =e4 into f1 and
=e6 into f2 but i want excel to recognise the pattern of data in the e column so that the
f column will have 1
2
3
4
5
6

displayed on it.

i hope that you can understand my quirey,
since i am working for a company i am unable to upload confidential information for the public to see,

 

[etizzle]

Hi Ali thanks for your reply...
this is a little hard to explain but i will try my best

what i am trying to achieve in the f column is 1,2,3,4,5,6 going downwards
i know that i can do this manually by saying =e4 into f1 and
=e6 into f2 but i want excel to recognise the pattern of data in the e column so that the
f column will have 1
2
3
4
5
6

displayed on it.

i hope that you can understand my quirey,
since i am working for a company i am unable to upload confidential information for the public to see,

i am using excel 2007