Hi,
yes, the post title Sounds weird (sorry)
Please i need expertise on how to create a sheet to generate Random numbers from 2 specific list
of a main list range of 36 Numbers. (List A = Specific 15 numbers, List B = The remaining Numbers from these 36)
Example :
-The Main List Range is from Number 01 to 36
-The Specific random list will be 15 Numbers of these 36
List A-.The Specific 15 Numbers are: 01,02,03,10,11,12,13,20,21,22,23,30,31,32,33
List B-.Remaining Numbers : 04,05,06,07,08,09,14,15,16,17,18,19,24,25,26,27,28,29,34,35,36
So
I need to generate ONE Unique Random Numbers of List A ( 01,02,03,10,11,12,13,20,21,22,23,30,31,32,33)
In Cell A1
In Cell A2
In Cell A3
And from List B, (04,05,06,07,08,09,14,15,16,17,18,19,24,25,26,27,28,29,34,35,36)
I need to do the samething In
Cell A4
Cell A5
Cell A6
A Dummy question.. (sorry, sometime i'm lil dum) : It's possible to have a 6 cells with random but Unique Digits?
(not repeated numbers between the 6 cell ??)
IMPORTANT NOTE :
If i came to this (ask you for help) Is because i already search about RANDOM and
tried to do it my self Using the RAND and RANDBETWEEN Formula (with no success)
Thank you so much !!
Best Regards from Miami
David
Bookmarks