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