View Single Post
  #1   Report Post  
bala_vb bala_vb is offline
Senior Member
 
Location: Hyderabad
Posts: 237
Thumbs up

Quote:
Originally Posted by pat67 View Post
Hey is there a way to generate random numbers like you would for a
draft. In other words, i have numbers 1 through 10 and generate a
random order for those?
in excel 2003:
=CEILING(RAND()*10,1)

in excel 2007 using RANDBETWEEN function
example: randbetween(1,10)


all the best
__________________
Thanks
Bala