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

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

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

"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

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

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

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