Duplicate numbers in column

[Haysie]

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?

 

[Andy B]

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.

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?