= Rand ()
Pull down C6
In B 1, enter:
=OFFSET(A$ 1，RANK(C 1，C$ 1:C$6)- 1，)
Pull down to B6 to get the result you want, and press F9 to refresh.