Select numbers from a Random of numbers

D

Dell

Greetings,

Is it possible to select several numbers from a random of numbers?

Example: I have column of random numbers - randbetween(1,52)

I would like to be able to select 3 of the random numbers and place in a
different column. Is this possible?

Thanks

Dell
 
M

Max

One quick way to set it up which might be acceptable :

Assume your column of 52 random numbers
is in A1:A52, and that the list has been frozen
(i.e. it contains values only)

Put in:

C1: =OFFSET($A$1,randbetween(1,17)-1,)
C2: =OFFSET($A$1,randbetween(18,34)-1,)
C3: =OFFSET($A$1,randbetween(35,52)-1,)

Between them, C1:C3 will return 3 "random" selections
from within the numbers listed in A1:A52, with:

C1 returning a number listed within A1:A17 (first 17 rows)
C2 returning a number listed within A18:A34 (2nd set of 17 rows)
C3 returning a number listed within A35:A52 (final set of 18 rows)

The range of 52 numbers listed in A1:A52 is sliced
into roughly 3 equal parts for the random selection
 
M

Max

LOL, .. seem unable to get through the day
without some offsets getting in the way <bg>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top