how can i assign i set of numbers (1-16) without repeating them?

S

Stew

i am wondering how to randomlly assign the numbers 1-16 to names, without
repeating the numbers....
 
N

N Harkawat

A non formula approach
First enter the numbers 1 thru 16 on cell A1:a16
then on B1 type
=Rand()
and copy it all te way down to B16
Selecting A1thru B16 do a sort by column B
The resulting Column A is your random list of unique numbers from 1 thru 16
Copy that and paste it next to those 16 names
 
Top