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