View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default 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

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