Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
getting numbers divisible by 4 from random numbers in ascending order | Excel Worksheet Functions | |||
How to select top six numbers from a of range of random numbers | Excel Worksheet Functions | |||
Can Excel pick random numbers from 1-300 and not repeat numbers? | Excel Discussion (Misc queries) | |||
Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) |