RANDOM NUMBER GENERATION.

[HARSHAWARDHAN. S .SHASTRI]

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

 

[Teethless mama]

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

 

[Gord Dibben]

http://www.mcgimpsey.com/excel/udfs/randint.html

Please drop the all caps. Hard on the ears.

Thamks


Gord Dibben MS Excel MVP

 

[HARSHAWARDHAN. S .SHASTRI]

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

=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+

 

[Teethless mama]

You're Welcome!

=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+

THANKS TEETHLESS MAMA.WORKING CORRECTLY.YOU ARE REALY BRAINWALA MAMA

HARSHAWARDHAN SHASTRI

INDIA

=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+