| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Random #'s for a population
How do you use the sort filter smallest to largest? When I try I see that
the numbers are changing not just reordering? Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Random #'s for a population
Assuming you are using a formula to generate the random numbers...
First, make the values static, then sort them. Or, use the LARGE/SMALL functions to reorder the numbers into a sorted list for you, if you want to be able to quickly get new numbers. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Anna" wrote: How do you use the sort filter smallest to largest? When I try I see that the numbers are changing not just reordering? Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting random Data created from a random formula | Excel Discussion (Misc queries) | |||
| Workbooy population | 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) | |||
| How do I find random number in list of random alpha? (Position is. | Excel Discussion (Misc queries) | |||
Linear Mode
