Hello !

In excel there is randbetween(x;y) which display random numbers between exactly given interval. e.g. randbetween(1;23) will give you random number between 1 and 23.
The question is how do you get random numbers from exactly given ones ?

e.g. Let's say you want excel to return random numbers between 1;12;23;35;37;45;53;75;95 and it should return to you only random chosen numbers from this given 'array' like 1 OR 12 OR 23 OR 35 OR 37 OR 45 OR 53 OR 75 OR 95 ONLY ONE number if you want to return only one but if you want it to return more then one then it should be: 1;12 OR 1;35 OR 1;53 if you want to return 2 of them and so on. It should be a formula like:
randbetween("values";"chosen by") eg. randbetween("1;12;23;35;37;45;53;75;95";3) will return to you combo from this array "1;12;23;35;37;45;53;75;95" taken by 3. Like 1;12;23 OR 1;12;53 and so on.

How could I do this in Excel ?

Any help, please ?

Thank you so much !