Select numbers from a Random of numbers

[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

 

[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

 

[Biff]

Max, you have a "thing" for offset, don't you? <g>

Biff

 

[Dell]

I like this but I have unfortunately not covered the offset as yet.

 

[Dell]

lol, can't wait to cover it none the less!

Max, you have a "thing" for offset, don't you? <g>

Biff

 

[Max]

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