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
Macro that sorts data with blanks at the bottom 1
Accessibilty - how to open doc with keyboard? 0
How do you randomly assign numbers without getting duplicates? 6
Trouble sorting a subtotalled list 0
Unable to sort "words" that are numbers and letters 5
Two Toggle Buttons to calculate Day(s) Hour(s) Minute(s) between entry time 1

Top