View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 17 random numbers between 1 to 65

=RANDBETWEEN(1,65)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Khoshravan" wrote in message
...
I have a list of 65 names sorted alphabetically. I want to choose 17 names
by
random. So my tasks is: how to choose 17 random numbers between 1 and 65.
I
know how to produce random numbers in Excel, but
I don't know how to locate them to be between 1 and 65 .

--
Rasoul Khoshravan Azar
Kobe University, Kobe, Japan