Unique random numbers from list
Are the numbers in A5:A105 unique -i.e. no duplicates?
Tyro
"Matt" wrote in message
...
I would like to create a function that would put 5 random numbers from
a list. The list is in cells A5:A105 and the five random selections
can go in B5:B9. I'm using the formula:
=INDEX(A:A,RAND()*COUNTA(A:A))
This formula does work most of the time but does not guarantee that
the five random selections are unique. Any ideas on how this can be
done?
|