LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Random Range with no duplicates

Here is my situation: I have a list of college classes. With each class -
lets say ENGL-1301 I need to generate a series of random section numbers with
no duplicates between 9001-9099. Then on the next class such as ENGL-1302 I
need to start over with the number system. There are different numbers of
classes in one class name - lets say ENGL-1301 has 20 sections and ENGL-1302
has 9 sections.

Thanks for any help!
 
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
Random generator using a range with range frequency Okstate_Fan131313 Excel Programming 3 August 4th 08 11:43 PM
Look for duplicates within a range Access Joe Excel Worksheet Functions 5 August 1st 08 09:18 PM
How to generate sets of random numbers without having duplicates William Excel Worksheet Functions 1 June 6th 06 05:30 AM
How can I create a list of random numbers with no duplicates? Kwasniewski Excel Discussion (Misc queries) 2 May 15th 06 02:44 AM
Showing a unique random number w/o duplicates tx12345 Excel Worksheet Functions 4 August 27th 05 02:51 AM


All times are GMT +1. The time now is 10:24 AM.

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

About Us

"It's about Microsoft Excel"