Solved

Repeating Series

Posted on 2013-05-11
1
395 Views
Last Modified: 2013-05-11
I have a list of numbers that is 1,271 numbers long. I need to create another list, in an adjacent column, that repeats the first number 10 times, then the second number 10 times, and the third number 10 times, etc, until the list is now 10 times as many cells long as the original column. Is there a quick way to do this using the fill series function and possibly a helper column?
0
Comment
Question by:Humb13St3ps
1 Comment
 

Accepted Solution

by:
Humb13St3ps earned 0 total points
Comment Utility
Figured it out. I made a formula in the adjacent column that equaled the cell of the first number in the 1st column. I repeated the formula in the 9 cells below. So the first 10 cells has a formula equaling the first cell in the 1st column. I then placed a formula in the 2nd set of 10 cells to equal the second number in the 1st column. I then used the series fill function to complete the rest of the series as needed.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
With the internet and the ease of information transference, many professional jobs can be done anywhere today.  Why should it make a difference whether an x-ray is read in India or the United States as long as the radiologist is qualified?   Outso…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

762 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

7 Experts available now in Live!

Get 1:1 Help Now