Thread: How can I sort a column of numbers generated by excel RAND funct?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default 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?
Reply With QuoteReply With Quote