Generate Random numbers from a pre-defined set

[frankjh19701]

Does anyone know how to setup a random number generator from
pre-defined set of numbers? For example, I have a series of number
across 10 columnsand down 2000 rows, and I want to select only a few o
them and run a random number analysis with them. To be able to pick 3
5, 7, or all ten numbers and run them to find all of the possible 3, 5
7, or 10 digit number variations. Anyone know

 

[frankjh19701]

Say we have a block of numbers from A1 thru J2000

In L1 enter:
=RANDBETWEEN(1,10)
(randon column)


In L2 enter:

=RANDBETWEEN(1,2000)
(random row)


In L3 enter:


=INDEX(A1:J2000,L2,L1)

to pick a single random item in the table

--
Gary's Student


:
-

I'm sorry, maybe I'm a little slow here, but this doesn't work or mak
any sense to me. I don't want to pick a lone single random number,
want to pick all of one numbers variation with the other numbers in
given range. What you presented only selects one random number b
itself, which doesn't help. I'm sorry to say.
Let's say you have a range of A:1 to H:1 and then all of those cell
are filled with numbers (Not sequential in any way), and you want t
select among them one number and find all of the possible variations o
that number with all of the other numbers. Like this:
The numbers are 3, 45, 12, 103, 67, 2, 111, 23 and you want to find al
of the variations (In a set of 4) that 3 contains. Does this make mor
sense? Let me know if it doesn't. Again, I appreciate any/all help tha
I can get

 

[Rothman]

Say we have a block of numbers from A1 thru J2000

In L1 enter:
=RANDBETWEEN(1,10)
(randon column)


In L2 enter:

=RANDBETWEEN(1,2000)
(random row)


In L3 enter:


=INDEX(A1:J2000,L2,L1)

to pick a single random item in the table

This works great for me ("randomly" choosing five numbers from 33).

 

[Gary''s Student]

I am sorry Frank. I now understand what you want, but I don't know how to do
it. I'll ask some other people at the Help Center.