Sub Macro1()
Application.ScreenUpdating = False
[B1].FormulaR1C1 = "=RAND()"
[B1].AutoFill Destination:=Range("B1:B" & Range("A65535").End(xlUp).Row)
[E1].Formula = "=INDEX($A$1:$A$" & Range("A65535").End(xlUp).Row & ",RANK(B1,$B$1:$B$" & Range("A65535").End(xlUp).Row & "))"
[E1].AutoFill Destination:=Range("E1:E14")
[E1:E14] = [E1:E14].Value
[B1:B939].Clear
Application.ScreenUpdating = True
End Sub