random number not duplicated

[B4L4KS]

hi

i need to add the numbers 1-20 into 20 boxes, the formula is =Random() but i need to know how to have non duplicate numbers.

the numbers can be random in the boxes just not the same

many thanks

kristian

 

[GlennUK]

You could have a separate area for generating the unique random numbers. Have a range of 20 cells with =RAND() , and from those generate unique numbers from 1-20 by using a ranking formula like this:

=RANK(A1,$A$1:$A$20)+COUNTIF($A$1:A1,A1)-1

... assuming the random numbers are in range A1:A20.

 

[B4L4KS]

hi

thanks glen it works and i have assigned a vlookup to pick up names located to each number

thanks again

kristian