"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

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