| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Random Numbers
Hey!
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??? thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| getting numbers divisible by 4 from random numbers in ascending order | Excel Worksheet Functions | |||
| I want random numbers generated without repeating numbers | Excel Worksheet Functions | |||
| Can Excel pick random numbers from 1-300 and not repeat numbers? | Excel Discussion (Misc queries) | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) | |||
![John Pivot Table[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
