Microsoft Office Forums - View Single Post - How to insert random numbers that equal a certain number

Thread: How to insert random numbers that equal a certain number

View Single Post

Old

11-17-2014, 08:11 PM

whatsup

whatsup is offline

whatsup uses Windows 7 64bit

Windows 7 64bit whatsup uses Office 2010 32bit

whatsup uses Office 2010 32bit

Office 2010 32bit

Competent Performer

Join Date: May 2014

Posts: 137

whatsup will become famous soon enough

Default

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...

Reply With Quote