I want to randomly fill an array of cells with values from a list I create

S

shadestreet

I have a column of with 4,500 cells.

I want the number in the cells to be randomly picked from a list of 2
choices, all predefined (20,27,40,54....296).

Can anyone help me with this? Thanks
 
A

Alan Beban

We probably need a little more information. What's in the 4500 cells?
What do you mean by "predefined? What do you mean by "I want the number
in the cells to be . . . picked"---"picked" by what?

Alan Beban
 
B

BrianB

Say your list of numbers is in cells A1:A20 the formula is :-

=INDEX($A$1:$A$20,INT(RAND()*20)+1)

These numbers will change each time the worksheet recalculates
 

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

Similar Threads

Help with Random Numbers 5
Random number macro 10
Help with randomly displaying values from a list. 1
INDES and #Value! 1
How to random pick a cell from more than one column 3
Randomly assigning Data 1
Pick random cell in VBA 0
Making random and unique selections from a list 2

Top