ExcelBanter - Random #'s for a population

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Random #'s for a population (https://www.excelbanter.com/excel-discussion-misc-queries/256413-random-s-population.html)

Anna

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?

Luke M

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?

All times are GMT +1. The time now is 09:47 AM.