| View previous topic :: View next topic |
| Author |
Message |
uj4 Newbie

Joined: 01 Feb 2009 Posts: 1
|
Posted: Sun Feb 01, 2009 12:31 pm Post subject: Treating multiple rows as one, for sorting |
|
|
Is there any way to treat multiple rows as one row for sorting purposes? In my spreadsheet each item has two rows of information. I would like to be able to sort these items, but need to make sure that both rows remain associated.
Thanks for your help. |
|
| Back to top |
|
 |
Hanns General User

Joined: 31 Aug 2007 Posts: 12
|
Posted: Sun Feb 01, 2009 12:37 pm Post subject: |
|
|
Id probably try to add a column, where each pair of row gets a 1 and a 2. What about the secondary sorting, that you see in the sorting dialog?
First sort as you would, secondary sort the new column with the 1 and 2s |
|
| Back to top |
|
 |
|