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.
|