| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting
i just grouped some rows together in my spreadsheet. that worked great, but
now i have trouble sorting and keeping this groups in the right order. any suggestions? thanks steve |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sorting
Hi,
The best way I have found to keep a group together is to creat another field, column, and give each group a unique ID. Thanks, "steve" wrote: i just grouped some rows together in my spreadsheet. that worked great, but now i have trouble sorting and keeping this groups in the right order. any suggestions? thanks steve |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sorting
You're right, i did that before and it worked. But i did have a quick
question about a helper column like that. the group will all have the same value in that additional column. will excel always keep the order within the group the same? "David" wrote: Hi, The best way I have found to keep a group together is to creat another field, column, and give each group a unique ID. Thanks, "steve" wrote: i just grouped some rows together in my spreadsheet. that worked great, but now i have trouble sorting and keeping this groups in the right order. any suggestions? thanks steve |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sorting
i'm having trouble with this, the group will not stick with the sort.
"steve" wrote: You're right, i did that before and it worked. But i did have a quick question about a helper column like that. the group will all have the same value in that additional column. will excel always keep the order within the group the same? "David" wrote: Hi, The best way I have found to keep a group together is to creat another field, column, and give each group a unique ID. Thanks, "steve" wrote: i just grouped some rows together in my spreadsheet. that worked great, but now i have trouble sorting and keeping this groups in the right order. any suggestions? thanks steve |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sorting
Hi,
Maybe you can use two cheater columns? Have not tried it, but I think a 1A, 1B, 1C, 2A, 2B, 3B, etc might work too. Thanks, "steve" wrote: i just grouped some rows together in my spreadsheet. that worked great, but now i have trouble sorting and keeping this groups in the right order. any suggestions? thanks steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Values Without Sorting Formulas | Excel Discussion (Misc queries) | |||
| Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
| Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
| Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
| Sorting ListBox results or transposing ListBox values to other cells for sorting | Excel Programming | |||
Hybrid Mode
