| Home |
| Search |
| Today's Posts |
|
#7
|
|||
|
|||
Hello Ragdyer from Steved
Excellent thankyou. "Ragdyer" wrote: You can try this: Enter =RAND() In AA1 and drag across to BN1, Then down to BN10, So you have a 40 column by 10 row array of random numbers. Then, enter this formula anywhere you wish: =INDEX(ROW($A1:$A40),RANK(AA1,$AA1:$BN1)) Now, copy this formula across 6 columns. Then, copy down 10 rows. This should give you what you're looking for. You'll get a new set of numbers with each hit of <F9. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Steved" wrote in message ... Hello Harlan from Steve I think i'm missing something here I followed what you put below naming the range PNRA ok =RAND() are in cell A1:F10 I highlighted and then I Insert Name Define please I am lost where do I put the below COUNTIF(PRNA,"<="&INDEX(PRNA,ROWS($C$5:C5)*6-COLUMNS($C$5:C5)+1)) Also do I change your $C$5:$C$5 to $A$1:$A$1 ok also please what is require to reconize the number between 1 to 40. Thankyou. "Harlan Grove" wrote: Steved wrote... .... Can your formula devoloped to display 6 columns across and 10 rows deep please. .... "Gary''s Student" wrote: If you need to randomly select 6 numbers from the range 1-40 with no repeats: 1. Enter the numbers 1-40 into an un-used column 2. Enter =RAND() into the cells of the adjacent column 3. Sort the two columns by the RAND column .... You don't need steps 1 or 3. All you need is a range of 60 cells (10*6) all containing =RAND(). If that range were named PRNA and the top-left cell of your 10 by 6 result range were C5, enter the following formula in C5. C5: =COUNTIF(PRNA,"<="&INDEX(PRNA,ROWS($C$5:C5)*6-COLUMNS($C$5:C5)+1)) Select C5 and fill right into D5:H5. Then select C5:H5 and fill down into C6:H14. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| random numbers, how can you utilize it without repeating them | Excel Discussion (Misc queries) | |||
| random numbers from a data of numbers? | Excel Worksheet Functions | |||
| Validating random numbers | Excel Worksheet Functions | |||
| Random Numbers Change? | Excel Worksheet Functions | |||
Threaded Mode
