Random Population from list

[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!

 

[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!

Have you looked at the RAND function?

 

[gumbah5]

> On 2/2/10 11:25 AM, in article (e-mail address removed)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
>

Thanks Bob,

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

Thanks,
greg

 

[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

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