Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how can i assign i set of numbers (1-16) without repeating them?
i am wondering how to randomlly assign the numbers 1-16 to names, without
repeating the numbers.... |
#2
|
|||
|
|||
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.... |
#3
|
|||
|
|||
See
http://www.mcgimpsey.com/excel/randint.html In article , "Stew" wrote: i am wondering how to randomlly assign the numbers 1-16 to names, without repeating the numbers.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
How do I assign sequential numbers in an invoice? | New Users to Excel | |||
Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
How do I assign sequential numbers in an Excel 2003 PO template? | Excel Worksheet Functions | |||
looking to assign different numbers in column B to different words in column A | Excel Worksheet Functions |