J Jay Feb 11, 2004 #1 How do I populate 25 cells in a random order with numbers 1 through 25 and without repeating any number.
How do I populate 25 cells in a random order with numbers 1 through 25 and without repeating any number.
H Harald Staff Feb 11, 2004 #2 Put your numbers in range A1:A25 In B1:B25 the formula =RAND() Sort by B column. Click F9 and sort again for a new shuffle.
Put your numbers in range A1:A25 In B1:B25 the formula =RAND() Sort by B column. Click F9 and sort again for a new shuffle.
