Select A Random Cell From A Defined Range No Dups

[moses]

Select A Random Cell From A Defined Range No Dups
I want to select a ramdom Bull in a rodeo and assign it to a rando
rider.
If you can help thanks (e-mail address removed)

 

[Frank Kabel]

Hi
if your data is in A1:A10 try
=INDEX(A1:A10,RANDBETWEEN(1,10))

 

[sulprobil]

Looks like you want unique random numbers (without
repetition).

Take my VBA script for example:
http://www.sulprobil.com/html/uniqrandint.html

If there are 40 bulls and 30 riders:

Select 30 cells to select 30 distinct bulls, type
=UniqRandInt(30)
CTRL+SHIFT+ENTER
Select another 30 cells for the riders and type same
formula again (as array formula). That's it.

If there are 30 bulls and 40 riders, you might first
select 30 cells to select all bulls randomly and then
another 10 cells to get 10 bulls a second time. Finally 40
cells to assign the riders.

HTH,
sulprobil