This may be the formula you are seeking
=RANDBETWEEN(9001,9099)
Skinman


"Darmahart" wrote in message
...
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!