help

[jinvictor]

i want do a worksheet contain:

A1 - A15 names
B1 - B15 random nos between 1-11

how can i do the random nos?
cheers

 

[KLEBESTIFT]

=INT(RAND()*11+1)

 

[Pete_UK]

Try this:

=INT(RAND()*11+1)

Hope this helps.

Pete