|
|
#4
11-21-2014, 07:26 PM
|
|||
|
|||
In the range of 85 to 645 there are 645-85+1=561 numbers.
If you take the first 21 ones you get a sum of 84*21*22/2 = 19404; if you get the first 22 ones you get a sum of 84*22*23/2 = 21252; and so on. In my opinion there is only one way to get 76 numbers summarizing 20000: - accepting duplicates by running VBA code. Is it ok for you? Bruno 
|
|
|
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 8 
Office 2013
Threaded Mode