i want do a worksheet contain:
A1 - A15 names
B1 - B15 random nos between 1-11
how can i do the random nos?
cheers
i want do a worksheet contain:
A1 - A15 names
B1 - B15 random nos between 1-11
how can i do the random nos?
cheers
=INT(RAND()*11+1)
Try this:
=INT(RAND()*11+1)
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks