Random Numbers


John Pivot Table


A question about random numbers in excel. I have a huge list of people and I
need to assign to each one a random number between 0.0 and 1.25.

The problem is I need the following:

70% of the people to be between 1 and 1.2
20% of the people to be above 1.2
10% of people below 1

any way I can do this randomly???


Mike H

see your other post

When competing hypotheses are equal, adopt the hypothesis that introduces
the fewest assumptions while still sufficiently answering the question.
Occam''s razor (Abbrev)

Bernie Deitrick

John PT,

How about a pseudo-random approach?

Let's say that your list of names is in column A, starting in A2, with a header cell in A1. In B2,
enter the formula


and copy down until you match 70 % of your names. Then use


and copy down to match the next 20%, and finish with


and copy down to match the last of your list.

(OR use, in B2


and copy down the whole way......)

This will create evenly distributed numbers (without duplication) close to the limits that you
describe (70% between 1 and 1.2 - how close depends on your population count). Then in C2, enter the


and copy down to match column B.

Then select columns B and C, copy and pastespecial values, then sort B and C based on column C, and
delete column C.

MS Excel MVP

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads