Random generator for 6 cols .
Hello all,
I am wanting to get a macro that can give 6 x random generated numbers based only on the numbers from cols B to G.
Results to go into cols H to M.
I know that there are many different combinations, and I don't know what limit is possible as to how many results can be produced.
Example in row 2.
Thanks.
I am grateful for all answers to my questions .
Also i give a reputation even if not answered .
when you say "based only on the numbers from cols B to G" what exactly do you mean? From the examples given all of the random values are equal or above the relevant column in B-G, is that what you mean?
If someone has helped you then please add to their Reputation
I don't understand exactly what you want, but here's a guess.
This solution generates every time you click on F9, 6 different random numbers chosen from the numbers in B2:F6.
Please
try in A8 and copyright until Y8 (exact 25 times)try in A9 and confirm with CTRL+SHIFT+ENTER if necessary:Formula:
Please Login or Register to view this content.try in G2 and confirm with CTRL+SHIFT+ENTER if necessary:Formula:Please Login or Register to view this content.Formula:Please Login or Register to view this content.
Is this something in the direction you are looking for?
I look forward to your feedback.
Last edited by HansDouwe; 09-02-2022 at 06:16 AM.
Only generate from the numbers I have in range B2:G6
If as example there were only 2 rows of numbers
7 13 21 27 31 34
10 16 24 30 34 37
Then generator would only use these 2 x rows . yes there are two numbers the same being 34 but this could only be selected once to give 6 numbers as a result .
Thanks .
Thx for your feedback.
Indeed, this random generator only picks numbers from your specified card with 25 numbers.
And after each draw of six numbers, the drawn numbers are thrown back.
There will never be duplicates in 1 row of six numbers.
But in different rows there can be duplicates. Is that exactly what it means?
If not then let me know.
Otherwise if you are satisfied with this answer, please consider adding reputation to any helpers you think have earned.
Yes, it's certainly producing 6 random numbers, let me test things out. Will come back to advise.
Thanks
Try this in H2:
=AGGREGATE(14,6,B$2:B$6,RANDBETWEEN(1,5))
in I2:
=AGGREGATE(14,6,C$2:C$6/(COUNTIF($H2:H2,C$2:C$6)=0),RANDBETWEEN(1,5-SUMPRODUCT(COUNTIF($H2:H2,C$2:C$6))))
With a macro:
This way you don't have issues with automatic calculations of rand()
Please Login or Register to view this content.
from a newbie :D
Please Login or Register to view this content.
Thanks to all, many great answers.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks