D David Hilberg Jul 27, 2007 #2 =Rand() If your cells are in B1:B10, put =Rand() in A1:A10, highlight A1:B10, and click the sort button. - David
=Rand() If your cells are in B1:B10, put =Rand() in A1:A10, highlight A1:B10, and click the sort button. - David