Select A Random Cell From A Defined Range No Dups

S

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
 
Top