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


"Stew" wrote in message
...
i am wondering how to randomlly assign the numbers 1-16 to names, without
repeating the numbers....