View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
scidoc scidoc is offline
external usenet poster
 
Posts: 4
Default Need to sort a row of data and automatically copy in to another ro

I have a row of 6 random ordered numbers. I with to find out how to
automatically copy them into another row and have them in Ascending numerical
order. I'm at a loss to figure out what function can do this.

Example:
Input 9 4 56 8 2 27

Output 2 4 8 9 27 56

Thanks, Scidoc