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.
 

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 how do you sort w/o changing #'s 3
Cannot sort data 1
Sorting numbers 4
Dealing with the error: unable to filter on excel hc home school 0
Cannot sort data 6
Keyboard Mistyping - as if a computer virus - only happens in Outlook (www.portal.office.com) 0
Setting column width in a table with a macro is not working 0
Sorting Columns by number of characters 1

Top