Random Numbers from a List of Numbers

[dls61721]

Can anyone tell me how to generate random numbers from a
list of numbers? RANDBETWEEN doesn't help, it includes
numbers that I don't/can't use.

Thanks!

 

[Max]

If duplicates are not an issue
try: http://tinyurl.com/yrz7n

If duplicates are an issue,
i.e. you want *unique* random picks from your list
try: http://tinyurl.com/2avs5

 

[Peo Sjoblom]

What's your list of numbers look like?
Assume your list was

1
3
5
8
10
12
16
20
30
40


in A1:A10

to get a random number from the above list


=INDEX(A1:A10,MATCH(INT(RAND()*(11-1)+1),{1;2;3;4;5;6;7;8;9;10},0))

or hard coded

=INDEX({1;3;5;8;10;12;16;20;30;40},MATCH(INT(RAND()*(11-1)+1),{1;2;3;4;5;6;7
;8;9;10},0))

 

[JE McGimpsey]

Take a look here:

A worksheet method for returning non-repeating integers
http://www.mcgimpsey.com/excel/randint.html