View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default 17 random numbers between 1 to 65

If I were you I would not use RANDBETWEEN function. It may gives you
duplicate numbers if you do 17 times


"Bob Phillips" wrote:

=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