Log In
Register
Home
Active Member
April 10, 2020
Offline
Good Day.. please help me with this.. these are my functions.. Column C =RAND()
Column A =RANK(C1,C$1:C$50)
Column B =1+MOD(A1-1,9)
Column B6 =SUM(B1:B5)
I wanted to generate different combinations of random numbers in Column A but with only one specific result in Column B6=Sum... i really dont know how to call that whether it is fixed value or return value or target value.. i hope you understand my english.. hoping for your immediate response.. good day.. thank u! 
See Answer
October 5, 2010
Offline
Hi Rhee,
If the value in B5 is fixed, then you are limited to the 'random' numbers you can use to in ColA that add up to the sum in B5. I don't see how using RAND is useful here.
I'm not really clear on what it is you are trying to achieve. Can you please try explaining this again, and attach a workbook with your data.
Regards
Phil
Active Member
April 10, 2020
Offline
Good day Sir Philip.. i would like to know on how to generate continuously different combinations of random numbers in A1:A5 but only one desired total sum in B6.. let's put it this in a simple way.. for example i wanted to generate 3 sets of numbers.. each set consists of 3 numbers.. then i want 9 to be the total sum for every 3 numbers of each set..
4 2 3
1 6 2
3 1 5
these are all equals to 9....
i hope you understand now.. thank u.. goodday.. hoping for your immediate response
October 5, 2010
Offline
Hi Rhee,
Are you always looking for 3 factors? Will the total always be 9? When you say 'continuously generate' are you looking to find all factors for a given number, at rhe same time. Or do you just want to find 1 set of factors and then another? One approach will probably need VBA, the other will not.
See attached for something that works but as I'm still not 100% sure of the limitations and requirements, it might be exactly what you want.
Enter a number in B1 to start.
Regards
Phil
Answers Post
Active Member
April 10, 2020
Offline
Yes Sir Philip thats it.. I want to find 1 set of factor for a given number and then another one, and then another one and then another one........... continuously for a given number... pls help me
1 Guest(s)
