Improve company productivity with a Business Account.Sign Up

x
?
Solved

Excel autofill pattern of numbers

Posted on 2013-05-24
2
Medium Priority
?
426 Views
Last Modified: 2013-05-24
Hi,

I want excel to autofill a pattern of numbers, repeating each pattern of numbers sequentially as shown below. Can anyone help?

1
1
1
1
2
2
2
2
3
3
3
3
4
4
4
4
0
Comment
Question by:mr_bungle89
2 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 2000 total points
ID: 39195349
Enter the four 1s
for the first number 2 enter this formula
=A2+1
A2 is the cell address of the first 1. Change it to whatever you have.
Copy this formula all the way down.


***Edited***
0
 

Author Comment

by:mr_bungle89
ID: 39195360
Perfect thanks
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question