A very easy way;

In A1 thru A5 enter data1
in A6 thru A17 enter data2

Continue until you reach 100% in A100

In B1 thru B100 enter:
=RAND()

then sort cols A & B by B

Any sample pulled from column A will satisfy the distribution in the average.
--
Gary''s Student - gsnu200814


"Bill" wrote:

I have a data set that I created a block grid and a random genereator for. I
would like to put a percentage in for each piece of data so that data 1 is
only 5%, data 2 is 12% etc... How do I assign those percentages?