Duplicate numbers in column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to use the RANDBETWEEN function to provide a column of numbers, say from 1 to 12. When I use this function I get duplicates in the column. What can I do to stop this so that no numbers are duplicated in the column?
 
Hi

One way is to type 1 - 12 in separate rows in a column. Alongside type
=RAND() and fill this down your range. You can now sort on this column to
randomise your numbers for you.

--
Andy.


Haysie said:
I am trying to use the RANDBETWEEN function to provide a column of
Click to expand...
numbers, say from 1 to 12. When I use this function I get duplicates in the
column. What can I do to stop this so that no numbers are duplicated in the
column?
 
Back
Top