Random Population from list

G

gumbah5

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi,

We're wanting to randomly populate a selection of cells from a set list (we're making Bingo sheets).

We are able to have a drop down menu in each cell in order to choose the data (but it's difficult to remember which items have already been placed).

Just wondering if there was a way to have the cells be automatically populated in random order?

Thanks in advance for any ideas or suggestions!
 
B

Bob Greenblatt

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
Hi,

We're wanting to randomly populate a selection of cells from a set list (we're
making Bingo sheets).

We are able to have a drop down menu in each cell in order to choose the data
(but it's difficult to remember which items have already been placed).

Just wondering if there was a way to have the cells be automatically populated
in random order?

Thanks in advance for any ideas or suggestions!
Click to expand...
Have you looked at the RAND function?
 
G

gumbah5

> On 2/2/10 11:25 AM, in article [email protected]2ac0, "[email protected]" wrote:
>
> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi,
>
> We're wanting to randomly populate a selection of cells from a set list (we're making Bingo sheets).
>
> We are able to have a drop down menu in each cell in order to choose the data (but it's difficult to remember which items have already been placed).
>
> Just wondering if there was a way to have the cells be automatically populated in random order?
>
> Thanks in advance for any ideas or suggestions!
> Have you looked at the RAND function?
>
> --
> Bob Greenblatt [MVP], Macintosh
> bobgreenblattATmsnDOTcom
>
Click to expand...

Thanks Bob,

Looks like the RAND function only applies to numbers? Or can it be adapted to address vocabulary words and such?

Thanks,
greg
 
B

Bob Greenblatt

Thanks Bob,

Looks like the RAND function only applies to numbers? Or can it be adapted to
address vocabulary words and such?

Thanks,
greg
Click to expand...
No, it only applies to numbers. But you can use it as an index into a list
to extract items at random.
Click to expand...
 
Top