|
|
#2
11-17-2014, 08:11 PM
|
|||
|
|||
Hi baha
Fill: E1 put your target (20000) F1 =SUM(B2:B76) G1 =E1/F1 B2 = RAND() C2 =INT(B2*$G$1) Copy B2 the column down to B76, and C2 down to C75, formula for C76 =E1-SUM(C2:C75) That will do the trick... 
|
|
|
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