Hi

Bernd Plumhoff posted this formula recently for generating random numbers
between two values (stored in A1 and B1) ... so select your 200 cells type
this formula and use control & enter to enter it into all the selected cells
at once.

=MIN($A$1,$B$1)+INT(RAND()*(MAX($A$1,$B$1)-MIN($A$1,$B$1)+1))

This however, doesn't weight them in any way.

Cheers
JulieD

"giles" wrote in message
...
I want to generate sample data - maybe 200 numbers from 1 to 7 but wieghted
towards one end - any ideas?