| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for Duplicating Rows
Could anybody tell me if it is possible to write in a Formula that will
duplicate the row by a set number of times. I have a spreadsheet where I need to duplicate each row upto 2,000 times, rather than copying the row and pasting it into 1,999 highlighted Rows does a formula exist to perform such a task? With my basic excel knowledge I imagine it looking something likk this - =DUPLICATE(R2x1999) but obviously that doesn't work. Please help to save me hours of work related boredom. -- James Dawson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicating rows help needed | Excel Worksheet Functions | |||
| Duplicating Rows Based on Cell Value | Excel Discussion (Misc queries) | |||
| How do I prevent rows from duplicating when sending a worksheet? | Excel Worksheet Functions | |||
| Issues with formula not duplicating | Excel Worksheet Functions | |||
| Formula for Duplicating Rows!! | Excel Discussion (Misc queries) | |||
Threaded Mode
