Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 211
Default 17 random numbers between 1 to 65

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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default 17 random numbers between 1 to 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


On Jul 11, 3:32 pm, Khoshravan
wrote:
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



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,718
Default 17 random numbers between 1 to 65

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


"Khoshravan" wrote:

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

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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






  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 211
Default 17 random numbers between 1 to 65

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" wrote:

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


On Jul 11, 3:32 pm, Khoshravan
wrote:
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




  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 17 random numbers between 1 to 65

And with that set-up, just press F9 to re-generate
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 211
Default 17 random numbers between 1 to 65

Thanks. I really want to know what does the combination of Index and Rank do,
to produce my desired results.
--
Rasoul Khoshravan Azar
Kobe University, Kobe, Japan


"Teethless mama" wrote:

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


"Khoshravan" wrote:

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

  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default 17 random numbers between 1 to 65

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" wrote in message
...
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" wrote:

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


On Jul 11, 3:32 pm, Khoshravan
wrote:
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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
getting numbers divisible by 4 from random numbers in ascending order ramana Excel Worksheet Functions 6 June 19th 07 06:41 PM
How to select top six numbers from a of range of random numbers Jack M Taylor Excel Worksheet Functions 4 January 30th 07 10:18 PM
Can Excel pick random numbers from 1-300 and not repeat numbers? Julian Excel Discussion (Misc queries) 1 June 7th 06 07:17 AM
Non-random numbers generated by excel's data analysis random gener Allie Excel Worksheet Functions 10 September 17th 05 06:19 AM
Non-random numbers generated by excel's data analysis random gener Harlan Grove Excel Discussion (Misc queries) 2 September 13th 05 04:06 PM


All times are GMT +1. The time now is 04:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"