RANDBETWEEN, No duplicates, Static

  • Thread starter Thread starter Bob G
  • Start date Start date
B

Bob G

Goals: 1. To create a six column table (for lottery
numbers, 1-54) with each "row" containing a unique number
(no duplicate numbers in the row). 2. To keep the
table "cells" static (i.e., no automatic recalculation of
the random numbers) after it is created (unless I
intentionally want to generate a new set of numbers).

Results so far: For each "cell" the formula =RANDBETWEEN
(BOTTOM,TOP) works as expected but goals 1 and 2 have not
been achieved.

Possible solutions?
 
Thanks, I viewed the MVP site as suggested but how do we
convert the random numbers to constants as mentioned in
the solution?
 
Hi
but this is outlines in this page. It stores the unique random numbers
in an array and puts them on a sheet?
 
Back
Top