Random #'s for a population

A

Anna

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?
 
L

Luke M

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.
 
Top