Random NUM Generator Help

[Brew]

How do you create a random number generator formula or VBA that generates the 120 random num values in cells Z1-Z120 from the list in cells E1-E1000, after comparing the num values in cells E1-E1000 to any num values listed in cells Y1-Y12.
Conditions:
The cells in column E uses the following formula type to auto generate it’s numerical values
Example:
E1=SMALL(A1:C1,1)&SMALL(A1:C1,2)&SMALL(A1:C1,3)
E2=SMALL(A2:C2,1)&SMALL(A2:C2,2)&SMALL(A2:C2,3)
And so on …….
E1000=SMALL(A1000:C1000,1)&SMALL(A1000:C1000,2)&SMALL(A1000:C1000,3)

Also the numerical values in cells Y1-Y12 are entered manually.
Thank you

Brew

 

[Oaktree]

How about Z1 =OFFSET($E$1,RANDBETWEEN(0,999),0) and copy down through Z120?

Not sure what you mean by "after comparing the num values in cells E1-E1000 to any num values listed in cells Y1-Y12". What exactly do you want to do with this comparison?

 

[Brew]

Let me clarify:
I would like cells Z1-Z120 to generate 120 most likely random 3 digit numbers from the 3 digit combinations in the Y column list from Y1-Y12. The combinations in the Y column are 3 digits, between 000-999, manually entered and may not have values in all 12 cells (Y1-Y12). Therefore, the random results should only compare the actual values in the list and ignore any blank cells in Y1-Y12. It will not exceed 12 values.

Example1:
Y1=063
Y2=684
Y3=228
Y4=051
Ans. Compare Y1 through Y4 to get 120 most likely 3 digit combinations in cells Z1-Z120

Example2:
Y1=063
Y2=684
Y3=228
Y4=051
Y5=872
Y6=024
Ans. Compare Y1 through Y6 to get 120 most likely 3 digit combinations in cells Z1-Z120

 

[Oaktree]

I think it's the same idea:

Z1=OFFSET($Y$1,RANDBETWEEN(0,COUNTA(Y:Y)-1),0)

What does "most likely random" mean? If it's "most likely", it's not random

 

[Brew]

Ok Thanks Oaktree, I mean most likely. but I type the following into Z1, then what do I place in Z2 and so on:
Z1=OFFSET($Y$1,RANDBETWEEN(0,COUNTA(Y:Y)-1),0)

Also, how do I execute, to get the results after I enter
the values in the y column?

 

[Zack Barresse]

Fyi: Posted at Ozgrid also: http://www.ozgrid.com/forum/showthread.php?t=28518

It's always nice to mention that you've cross-posted at another forum. A lot of people here frequent multiple forum's. It's more or less a courtesy call.

 

[Brew]

I do apologize:
See additional comments and offer your suggestions on the following thread:
Fyi: Posted at Ozgrid also: http://www.ozgrid.com/forum/showthread.php?t=28518
as suggested> Thank you