View Single Post
  #5   Report Post  
Dave Peterson
 
Posts: n/a
Default

You've got more suggestions at your other posts in .excel.

Patrick Simonds wrote:

I have a worksheet with 5 columns and 5 rows. A number gets entered into
each cell (A1:E5). I need to sort so that each number is placed in
sequential order (smallest to largest) across the columns and down the rows
(see example below). Can this be done?

1 2 3 4 5
6 7 8 9 10
11 12 13 14 15
16 17 18 19 20
21 22 23 24 25


--

Dave Peterson