Random name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

perlaparedes@gmail.com - 17 Aug 2006 01:38 GMT

hello,

Does anyone know the formula for random name selection using one
column?

thanks,

Reply to this Message

Biff - 17 Aug 2006 04:57 GMT

One way:

Assume you have 15 names in the range A1:A15.

=INDEX(A1:A15,INT(RAND()*15)+1)

Will return a different name (although repeats are possible) every time a
calculation is triggered. To make a new selection just press F9.

Biff

> hello,
>
> Does anyone know the formula for random name selection using one
> column?
>
> thanks,

Reply to this Message