GENERATE RANDOM NUMBERS TO FIT INTO RESULT OF PARTICULAR NUMBER

  • Thread starter Thread starter chozzecz
  • Start date Start date
C

chozzecz

HI TO ALL, I NEED HELP WITH SOME PROBLEM......

what I need is to randomly generate numbers (each with different
condition, some between 1 - 5, some between 10 - 20 ect) wich will fit
at summary into particular number I want.

example:

2 -
4 -
5 - numbers that will be randomly generated to fit into result 20
7 -
2 -
-
20 this is number I put by myself into column

any advice are willcome......pls

I did some research but it seems to me that maybe I need to use visual
basic for this wich i dont know.

chozzecz
 
Hi

so you want to tell excel how many numbers you need and the value they need
to sum to and you want excel to generate these for you?
do you also want to specify the maximum and minimum values between which the
random numbers can be generated?
are negative numbers allowed?

just a note, as far as i can tell, this is not an easy undertaking ...

Cheers
JulieD
 
Hi exactly, you have transleted it maybe to more understandable english
than is mine :-).

for all your questions , answer is YES, except note about negative
numbers.... negative numbers could not be allowed....

hope sometime I solve this task , It saves me a lot of time.....

bye

chozzecz
 
Hi

if you'ld like to email me direct (julied_ng at hcts dot net dot au) i
have a sample workbook for you

Cheers
JulieD
PS it's 3am here so i might not get to email it to you until tomorrow :)
 
Hi All

at the end I dont work with random numbers, clever guy told me to use
solver-addin and send me example.

here I describe my problem very simple, but i want to put revenue
number and see what pcs of every stuff I have to sell to get this
revenue. Also every stuff should have condition (sell between 10 - 50
pcs).

here is link what can solve your problem if it is same as mine.

http://office.microsoft.com/en-us/assistance/HA011118641033.aspx

I can also send you a spreadsheer with example if you want

ok c u
 
Back
Top