Create a 9 row vector with the name Randy. Fill with
=RAND()
Create an adjacent 9 row vector named Sandy. Fill with
=RANK(Randy,Randy)
Hit F9 until the first row of Sandy is equal to G1.