how to extract randomly a number based on a matrix

[jamiguel77]

hi all

based on this thread:

how to random all numbers

i have this table...

www.mrexcel.com

with this formula i generated 700 numbers Unique (see the post, please)
=WRAPROWS(TAKE(SORT(HSTACK(SEQUENCE(700),TAKE(UNIQUE(RANDARRAY(10000,1,1,100000,1),FALSE,FALSE),700)),2,1),,1),5)

My question now is:

from these matrix generated, how to take randomly 1 number? and put the result on, G2

i am think in a formula RANDOM.BETWEEN(1,700) but i am not sure,
but I would like it better the other way
Thanks

 

[Cubist]

I'm not following something here. If you're using an array to generate a table of random numbers and you only want 1 value, why don't you shrink the array to just 1 element?

 

[jamiguel77]

If you notice there are 140 lines with 5 numbers, 140 people will sign up and in the end they will be given something to the number that appears in G2

 

[Cubist]

Yes, I see you have 700 unique numbers.

Why are you generating 700 unique numbers on the sheet and then selecting 1 random number from the 700 unique numbers?

Why can't you skip the table altogether and do this?

=RANDBETWEEN(1,700)

 

[Fluff]

Like Cubist, I'm not quite sure what you are after, but you can simplify your current formula to

=WRAPROWS(SORTBY(SEQUENCE(700),RANDARRAY(700)),5)