what is thhe formula to randomize a list?? thank You Shalom Leland
D Dave Peterson Jul 13, 2009 #2 I add a helper column filled with formulas (=rand()) Then I sort the entire range by that helper column.
I add a helper column filled with formulas (=rand()) Then I sort the entire range by that helper column.
