Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello friends: I need some help. I know how to do sorting in general but I am
not an excel expert. The problem is as shown below: 37.66 38 38 38 38 38.25 97.2 100 92 100 78.7 100 ..5 38.25 55 88.5 100 16 23.75 10 56 10 18.75 19.2 53.5 8.4 100 9.75 10.75 43.75 56.25 9 10 12.5 12.86 16 The above is a smaller version. I have almost 100 columns or more. I want to sort each column from 'smallest to largest'. They are all independent. I do not want to go column by column sorting each of them. Is there a way to sort the entire thing in such a way that each column has its contents sorted from small to large. I appreciate all the help. Thanks in advance. amstro. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting Multiple Columns | Excel Discussion (Misc queries) | |||
Sorting multiple columns | New Users to Excel | |||
Sorting in multiple columns | Excel Discussion (Misc queries) | |||
sorting data across multiple columns | Excel Discussion (Misc queries) | |||
Sorting multiple columns together | Excel Discussion (Misc queries) |