| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting every other line
I created a spreadsheet to list my entertainment collection (movies, music,
etc). I have the title in 1 row, then the description in the next row. For example: 1 Star Wars 2 George Lucas' film about........ 3 Austin Powers 4 Mike Myers stars in this film...... Is there a way that I can sort this spreadsheet by every OTHER row, and keep the next row together with that sort. In other words I want to sort by title and have the description linked with that title so it gets sorted along with the title. Any help would be greatly appreciated. Thanks in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting every other line
Wouldn't it be easier to have
1-2 start wars George 3-4 Austin etc -- Don Guillett SalesAid Software "Jspagnoli" wrote in message ... I created a spreadsheet to list my entertainment collection (movies, music, etc). I have the title in 1 row, then the description in the next row. For example: 1 Star Wars 2 George Lucas' film about........ 3 Austin Powers 4 Mike Myers stars in this film...... Is there a way that I can sort this spreadsheet by every OTHER row, and keep the next row together with that sort. In other words I want to sort by title and have the description linked with that title so it gets sorted along with the title. Any help would be greatly appreciated. Thanks in advance. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting every other line
Put the key value (the movie title) in a cell in each row. And add an indicator
to show what row it is. New Col A B Star Wars 01 Star Wars ... Star Wars 02 George Lucas' film about... Then you can sort using column A as the primary key and columm B as the secondary key. Jspagnoli wrote: I created a spreadsheet to list my entertainment collection (movies, music, etc). I have the title in 1 row, then the description in the next row. For example: 1 Star Wars 2 George Lucas' film about........ 3 Austin Powers 4 Mike Myers stars in this film...... Is there a way that I can sort this spreadsheet by every OTHER row, and keep the next row together with that sort. In other words I want to sort by title and have the description linked with that title so it gets sorted along with the title. Any help would be greatly appreciated. Thanks in advance. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW TO COLOR ACTIVE LINE CURSOR IS ON WHEN MOVING | Excel Discussion (Misc queries) | |||
| coloring overy other line without doing so line by line | Excel Worksheet Functions | |||
| When sorting info in columns, can I make it insert blank line bet. | Excel Worksheet Functions | |||
| Line chart - date line association gone mad! | Charts and Charting in Excel | |||
| Macro - Skipping a line | Excel Worksheet Functions | |||
Linear Mode
