| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Repeat values in a list x number of times
On sheet 1 I have numbers in A2 to A50, (about 50 or 55 maybe 60 numbers.)
1230 1001 2354 ..... ..... etc. On sheet 2 I want to repeat each number 7 times in A2 to A356 (or there about). Seven of each value on sheet 2 for as many rows as it takes. The numbers are unique, but would be helpful to know if it will work if there are some duplicates, or what problems to look out for if there are duplicates. To solve for unique values only is first priority. Thanks, Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| repeat number multiple times | Excel Discussion (Misc queries) | |||
| repeat list 5 times | Excel Discussion (Misc queries) | |||
| LIST OF THE NUMBERS, AND HOW MANY TIMES THEY REPEAT? | Excel Worksheet Functions | |||
| Repeat statements "x" number of times... | Excel Discussion (Misc queries) | |||
| how do I get a calculation to repeat various number of times? | Excel Worksheet Functions | |||
Threaded Mode
