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...
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...
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?
Better if you could explain your requirement with a sample file.
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
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
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
try this...
1. Type the starting number 20013 in Cell A1
2. In cell A2 insert the formula
3. Drag untill you need the required numbers each repeating for 20 instances.Please Login or Register to view this content.
Best
Rem0
am sorry...am basic user in excel..can u explain it clearly
Thank you remo..if i have to do it for more than 20 instances...how i should change the formula
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.
Thanks alot..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks