Solved

Excel autofill pattern of numbers

Posted on 2013-05-24
2
386 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 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

863 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now