How to repeat the series of numbers

[Latha Mani]

Hi
i want to repeat series like
20013 20013 20013 20013 20013 20013 20013 20014 20014 20014 20014 20014 20014 20014 20015 20015 20015 20015 20015 20015 20015 so on..

please help...

[alvin-chung]

Hi, how many numbers would you want to repeat e.g. 20013-20111?
Do you want all these numbers to be in ONE cell separated by a space?

[Rem0ram]

Better if you could explain your requirement with a sample file.

[Latha Mani]

No...i want 20013 to be repeated 20 times and 20014 to be repeated 20 times and 20015 to repeated 20 times upto 20070...i need all the numbers to be repeated 20 times in a column

[Latha Mani]

No...i want 20013 to be repeated 20 times and 20014 to be repeated 20 times and 20015 to repeated 20 times upto 20070...i need all the numbers to be repeated 20 times in a column

[alvin-chung]

Try:

1. Key in 20013 in cell A1
2. In name box, key in A1:A58 (you have 58 numbers to populate) and press Enter
3. Home menu > Fill > Series > OK (make sure series in column, linear type and step value=1)
4. press ctrl+c to copy A1:A58
5. In name box, key in A1:1160 (you want to populate 20 times for each number) and press Enter
6. press ctrl+v to paste
7. select cell A1 > Data menu > sort smallest to largest (icon with AZ arrow pointing downwards)



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

[Rem0ram]

try this...

1. Type the starting number 20013 in Cell A1
2. In cell A2 insert the formula

Please Login or Register  to view this content.

3. Drag untill you need the required numbers each repeating for 20 instances.

Best
Rem0

[Latha Mani]

am sorry...am basic user in excel..can u explain it clearly

[Latha Mani]

Thank you remo..if i have to do it for more than 20 instances...how i should change the formula

[Rem0ram]

you have to change the number after > symbol in the formula with 1 count less.

For example if you want to change it with 25 instances then the formula will be like this....

Please Login or Register  to view this content.

[Latha Mani]

Thanks alot..