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

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

Guest

i am wondering how to randomlly assign the numbers 1-16 to names, without
repeating the numbers....
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Want to count all repeated number only once in Excel 2007. 2
table formula 19
Excel Vertical to horizontal repeat after 16 rows 3
Random Assignment of Numbers 2
ROUNDUP to nearest 1/16 (in decimals) 0
Formula (or code) return the largest number of duplicates in a list. 16
assign a number to the same date & start over with 1 on new date 3
Unique Counting With Multiple Criteria 8

Back
Top