View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darmahart Darmahart is offline
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!