Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]()
Okay; this is clear.
What you'll want to do is select the values in Row 1 that you want to sort, then "Data / Sort" and click the "Options" button in the dialog box. You want to "Sort by Row" (I think--I'm not at Excel right now). Back at the dialog box you'll select the row to sort. Then do the same operation for each of the following rows. Finally, you'll come back again and do a sort by each column. Finally, you'll have a sorted matrix with lower values at top right, higher ones at bottom right. I'm sure there will be a much more elegant way to arrive at this arrangement using worksheet functions and no physical sorting of the data (which I would not normally perform, as the order the data is received and recorded usually has significance). But this should get you where you say you want to be. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Running total w/2 columns - Excel | Excel Worksheet Functions | |||
Advice sought: Multiple column sorting | Excel Worksheet Functions | |||
In Excel, sorting columns automatically by clicking column title | Excel Discussion (Misc queries) | |||
How 2 separate column of addresses into a colum of names and numb | Excel Discussion (Misc queries) | |||
Adding a KeyID column for sorting | New Users to Excel |