Thanks,

But I'm getting a circular reference, because I don't think I quite
explained what I have very well. This formula that I'm using
- =INDEX($B$1:$B$100,RAND()*100+1)
Is in a totally different cell (G18), that is showing the result.
If I have the # 4 in the cell next to Steve [S1]( and that # will change
every week), and a # 7 in the cell next to Tom [S2] ( and that # will also
change every week), how can I get 4 Steve's in that B column, 7 Tom's in that
B column, etc.
And to have the differing amounts of Steve & Tom the next week ?

Thanks again,
Steve


"T. Valko" wrote:

No need to create the repeated name list.

Try this:

R S
1 Steve 4
2 Tom 7
3 Don 9

In T1 enter 1

Enter this formula in T2 and copy down to T3

=S1+T1

Then:

=INDEX(R1:R3,MATCH(RAND()*SUM(S1:S3)+1,T1:T3))

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
I'm using the following to produce a random picking of names in the B
column.
=INDEX($B$1:$B$100,RAND()*100+1)
Each name is entered a different number of times in the B column, so that
the names entered the most have a higher probability if hitting.
What I'd like to have is another cells/columns that will auto-enter the
names in the B column the proper # of times.
E.g. If I have the following:
R S
1 Steve 4
2 Tom 7
3 Don 9

So that Steve is entered in the B column 4 times, Tom 7 times, Don 9
times,
etc.
Is this possible ?

Thanks,

Steve