17 random numbers between 1 to 65

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 .
 
They don't need to be between 1 and 65. Just put random numbers in a
helper column next to your names and then sort using the random
numbers as a key - then just take the top 17 names (or the bottom 17,
or 17 from the middle).

Hope this helps.

Pete
 
=RANDBETWEEN(1,65)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Assume name in A1:A65
In B1: =RAND()
copy down to B65

In C1: =INDEX($A$1:$A$65,RANK(B1,$B$1:$B$65))
copy down to C17
 
If I were you I would not use RANDBETWEEN function. It may gives you
duplicate numbers if you do 17 times


Bob Phillips said:
=RANDBETWEEN(1,65)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
Click to expand...
 
thanks. when I want to sort the column with random numbers, they change as
Excel recalculates the random function. I think I have to copy/special paste
with values to sort this column. Am I right?
--
Rasoul Khoshravan Azar
Kobe University, Kobe, Japan


Pete_UK said:
They don't need to be between 1 and 65. Just put random numbers in a
helper column next to your names and then sort using the random
numbers as a key - then just take the top 17 names (or the bottom 17,
or 17 from the middle).

Hope this helps.

Pete
Click to expand...
 
Thanks. I really want to know what does the combination of Index and Rank do,
to produce my desired results.
 
Why worry? You've done your sort based on a random order. Do you need to
be worried if the column now has a different random order in it?
--
David Biddulph

Khoshravan said:
thanks. when I want to sort the column with random numbers, they change as
Excel recalculates the random function. I think I have to copy/special
paste
with values to sort this column. Am I right?
Click to expand...
 
Back
Top