| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I sort a column of numbers generated by excel RAND funct?
After generating a column of numbers using the random number generator in
Excel, I tried to sort the column low to high. The sort appears to be random and additional sorting only yields a random column of numbers. How do I fix the numbers for normal sort? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I sort a column of numbers generated by excel RAND funct?
Create a helper column
=SMALL($A$1:$A$100,ROW()) copy down "Erick K" wrote: After generating a column of numbers using the random number generator in Excel, I tried to sort the column low to high. The sort appears to be random and additional sorting only yields a random column of numbers. How do I fix the numbers for normal sort? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I sort a column of numbers generated by excel RAND funct?
Every time you sort your numbers they are recalculating.
To sort a column of random numbers you could swith calculation to manual. Tools|Optiona|calculation|Manual Mike "Erick K" wrote: After generating a column of numbers using the random number generator in Excel, I tried to sort the column low to high. The sort appears to be random and additional sorting only yields a random column of numbers. How do I fix the numbers for normal sort? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I sort a column of numbers generated by excel RAND funct?
Teethless wrote on Fri, 27 Jul 2007 07:28:03 -0700:
Tm =SMALL($A$1:$A$100,ROW()) Tm copy down Tm "Erick K" wrote: ?? After generating a column of numbers using the random ?? number generator in Excel, I tried to sort the column low ?? to high. The sort appears to be random and additional ?? sorting only yields a random column of numbers. How do I ?? fix the numbers for normal sort? Another possibility would be to special paste the column as value and sort that. James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.verizon.not |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I sort a column of numbers generated by excel RAND funct?
"Erick K" wrote: After generating a column of numbers using the random number generator in Excel, I tried to sort the column low to high. The sort appears to be random and additional sorting only yields a random column of numbers. How do I fix the numbers for normal sort? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I sort a column of numbers generated by excel RAND funct?
You would need to convert the functions to values prior to sorting, since
sorting usually forces a recalc. Bernie "ret415" wrote in message ... "Erick K" wrote: After generating a column of numbers using the random number generator in Excel, I tried to sort the column low to high. The sort appears to be random and additional sorting only yields a random column of numbers. How do I fix the numbers for normal sort? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Corrosponding excel generated numbers with 1st row numbers | Excel Worksheet Functions | |||
| Difficulty adding RAND generated numbers | Excel Discussion (Misc queries) | |||
| Can I ignore numbers and sort only text in an Excel column? | Excel Discussion (Misc queries) | |||
| How to 'freeze' the output generated by RAND()? | Excel Worksheet Functions | |||
| to find missing serial numbers in randomly generated numbers | Excel Worksheet Functions | |||
Linear Mode
