Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Stew
 
Posts: n/a
Default 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   Report Post  
N Harkawat
 
Posts: n/a
Default

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   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Checking Winning Numbers in the Lottery. Ann Excel Discussion (Misc queries) 4 May 18th 05 10:55 AM
How do I assign sequential numbers in an invoice? halex New Users to Excel 4 May 5th 05 06:46 PM
Count and Sum Total occurrances of two specific numbers Sam via OfficeKB.com Excel Worksheet Functions 10 March 29th 05 08:13 PM
How do I assign sequential numbers in an Excel 2003 PO template? skiusa Excel Worksheet Functions 1 March 28th 05 10:57 PM
looking to assign different numbers in column B to different words in column A mike Excel Worksheet Functions 2 January 13th 05 02:46 AM


All times are GMT +1. The time now is 04:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"