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

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

Mike H

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

Gord Dibben

Are you using the volatile RAND function?

Copy/paste special/values before sorting.


Gord Dibben MS Excel MVP
 
×

מיכ×ל (מיקי) ×בידן

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Random #'s for a population 1
Cannot sort data 6
How do you randomly assign numbers without getting duplicates? 6
Unable to sort "words" that are numbers and letters 5
Sort will only sort text from smallest to largest? 2
Create List based on cell data 3
How can I sort a column of numbers generated by excel RAND funct? 5
table w/ some columns as drop down 1

Top