|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 21st, 2008, 05:10 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
RANDOM NUMBER GENERATION.
WHAT I NEED IS RANDOM NUMBERS SAY 1 TO 10 IN CELLS A1:A10 AND CONDITION IS
THAT NO NUMBER SHOULD REPEAT. CAN ANY ONE GIVE ME SOLUTION. THANKS HARSHAWARDHAN.SHASTRI INDIA 
|
|
#2
September 21st, 2008, 05:44 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
RANDOM NUMBER GENERATION.
Enter 1 to 10 in cells A1:A10
In B1: =RAND() In C1: =INDEX($A$1:$A$10,RANK(B1,$B$1:$B$10)) copy down to C10 "HARSHAWARDHAN. S .SHASTRI" wrote: WHAT I NEED IS RANDOM NUMBERS SAY 1 TO 10 IN CELLS A1:A10 AND CONDITION IS THAT NO NUMBER SHOULD REPEAT. CAN ANY ONE GIVE ME SOLUTION. THANKS HARSHAWARDHAN.SHASTRI INDIA
|
|
#3
September 21st, 2008, 05:44 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
RANDOM NUMBER GENERATION.
http://www.mcgimpsey.com/excel/udfs/randint.html
Please drop the all caps. Hard on the ears. Thamks Gord Dibben MS Excel MVP On Sun, 21 Sep 2008 09:10:01 -0700, HARSHAWARDHAN. S .SHASTRI wrote: WHAT I NEED IS RANDOM NUMBERS SAY 1 TO 10 IN CELLS A1:A10 AND CONDITION IS THAT NO NUMBER SHOULD REPEAT. CAN ANY ONE GIVE ME SOLUTION. THANKS HARSHAWARDHAN.SHASTRI INDIA
|
|
#4
September 21st, 2008, 05:55 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
RANDOM NUMBER GENERATION.
"Teethless mama" wrote: Enter 1 to 10 in cells A1:A10 In B1: =RAND() In C1: =INDEX($A$1:$A$10,RANK(B1,$B$1:$B$10)) copy down to C10 =+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+ =+=+=+=+=+ THANKS TEETHLESS MAMA.WORKING CORRECTLY.YOU ARE REALY BRAINWALA MAMA HARSHAWARDHAN SHASTRI INDIA =+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+ =+=+=+=+
|
|
#5
September 21st, 2008, 06:01 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
RANDOM NUMBER GENERATION.
You're Welcome!
"HARSHAWARDHAN. S .SHASTRI" wrote: "Teethless mama" wrote: Enter 1 to 10 in cells A1:A10 In B1: =RAND() In C1: =INDEX($A$1:$A$10,RANK(B1,$B$1:$B$10)) copy down to C10 =+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+ =+=+=+=+=+ THANKS TEETHLESS MAMA.WORKING CORRECTLY.YOU ARE REALY BRAINWALA MAMA HARSHAWARDHAN SHASTRI INDIA =+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+ =+=+=+=+
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
