random #'s for a population how do you sort w/o changing #'s
 

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?

random #'s for a population how do you sort w/o changing #'s
 

Anna,

As you correctly observe the numbers change because the sort causes the
worrksheet to recalculate. There are a number of ways around it.

One suggestion is copy your random numbers and paste special/paste values
into another range and then sort this range
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


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

random #'s for a population how do you sort w/o changing #'s
 

Are you using the volatile RAND function?

Copy/paste special/values before sorting.


Gord Dibben MS Excel MVP


On Tue, 16 Feb 2010 11:01:02 -0800, 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?

random #'s for a population how do you sort w/o changing #'s
 

Suppose you random numbers are in range A1:A20,
in cell B1, type: =SMALL(A1:A20,ROW()) and copy down.
Every press on [F9] will re-generate a new set of numbers which will be
automatically sorted, in Col. B
Micky


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