Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get random numbers from a certain range?
I have 468 unique numbers and need to select, at random, 64 numbers that do
not repeat. How do I get Excel to do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get random numbers from a certain range?
Assuming your numbers are in A2:A469...
In B2:B469, enter =RAND() and then sort A and B based on B, and take the top 64 (A2:A65) OR: you can use formulas to pull a different set of 64 each time you re-calc, which may not be what you want. HTH, Bernie MS Excel MVP "Random numbers" <Random wrote in message ... I have 468 unique numbers and need to select, at random, 64 numbers that do not repeat. How do I get Excel to do this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get random numbers from a certain range?
Put your values in B1 thru B468.
In A1 enter: =RAND() and copy down In C1 thru C64 enter: =VLOOKUP(LARGE(A$1:A$468,ROW()),$A$1:$B$468,2,FALS E) -- Gary''s Student - gsnu200908 "Random numbers" wrote: I have 468 unique numbers and need to select, at random, 64 numbers that do not repeat. How do I get Excel to do this? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get random numbers from a certain range?
Hello,
If your numbers are in A1:A468, select 64 cells and array-enter =Random_Pick(A1:A468) My UDF Random_Pick you can get he http://sulprobil.com/html/random_pick.html Regards, Bernd |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get random numbers from a certain range?
Set up a table in Dand E columns with the D column from 1 to 468
and E column is your list of unique numbers in B column you enter a vlookup formula and extend it to 64 rows =VLOOKUP(A1,$D$1:$E$468,2,FALSE) Assign the following macro to a button Sub TheBestLuckyLottoPicker() Dim t As Integer, m As Integer k = 64: n = 468 Do While m < k Randomize If (n - t) * Rnd() < k - m Then m = m + 1 Cells(m, 1) = t + 1 End If t = t + 1 Loop End Sub This macro will produce 64 random numbers from 1 to 468 they will be sorted in the A column the lookup formula will give you your unique numbers. Greetings from New Zealand "Random numbers" <Random wrote in message ... I have 468 unique numbers and need to select, at random, 64 numbers that do not repeat. How do I get Excel to do this? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get random numbers from a certain range?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unique RANDOM NUMBERS within specified range | Excel Worksheet Functions | |||
How to generate random numbers from a range of cells? | Excel Worksheet Functions | |||
how do you shuffle a range of numbers at random | Excel Worksheet Functions | |||
How to select top six numbers from a of range of random numbers | Excel Worksheet Functions | |||
Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) |