Autofill for cells in a certain pattern

E

etizzle

New Member
Joined
Apr 1, 2017
Messages
16
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,
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Sort by date Sort by votes
C0 to C33 is not an increment of 32.

If you select G6:G7 and drag down it should increment as required.
 
Upvote 0
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
 
Upvote 0
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
 
Last edited:
Upvote 0
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,
 
Upvote 0
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.
 
Last edited:
Upvote 0
etizzle said:
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
Click to expand...

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.
 
Upvote 0
etizzle said:
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,
Click to expand...
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
 
Upvote 0
Here's what I get:


Excel 2016 (Windows) 32 bit
IJ
201
33233
46465
59697
6128129
7160161
8192193
9224225
10256257
11288289
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.
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
Match a minimum of 3 and a max of 5 numbers for each row and add the number of cells containing the match displaying in G2 along each row
Replies
4
Views
331
smozgur
smozgur
ibmy
  • Solved
Find Number Pattern in Data - need 1 Column solution
Replies
7
Views
523
Peter_SSs
Peter_SSs
N
  • Question
Count - specific consecutive order
Replies
6
Views
472
Peter_SSs
Peter_SSs
E
  • Solved
move to next cell
2
Replies
10
Views
786
rollis13
rollis13
A
  • Question
How to enter a task start date based on the end date of a previous task. LONG
Replies
1
Views
374
abuchanan
A

Forum statistics

Threads
1,214,391
Messages
6,119,247
Members
448,879
Latest member
oksanana

Share this page

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
Back
Top