|
|
#6
11-22-2014, 06:14 AM
|
||||
|
||||
Quote:
To show how simple it is to get a series of 75 unique numbers that add to 20000, simply insert: =INT(317.75-ROW()*4/3) and copy down to row 75. The sum of the rows will be 20000. Granted, these numbers aren't random, but they also go nowhere near exhausting the possibilities contemplated by the OP.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Filling cells with random numbers using loops? (VBA) | Sajj | Excel Programming | 4 | 04-10-2013 02:29 PM |
| Random number difficulties | ahrinn | Word | 12 | 08-01-2012 01:04 PM |
| Random number generator for Powerpoint 2011 | kala85 | PowerPoint | 0 | 11-19-2011 06:16 AM |
| How to fill a cell with random numbers to do calculations? | zanat0s | Excel | 1 | 06-13-2011 10:33 AM |
| Display Random Numbers as Transition | greenbutton | PowerPoint | 0 | 03-09-2011 04:43 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode