Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Group cells and sort
Is it possible to group rows and have the sheet sorted by the first item in
the group? ie, we have orders with multiple items, and every item is on a separate row, so if we wanted to sort the orders by the first item on the order, is it possible to have that done and maintain the orders together?. ie I would want this: order sku name 1 789 Bob 1 456 Bob 2 456 Sue 3 789 Joe 3 123 Joe 4 456 Jodi Sorted like this: order sku name 2 456 Sue 4 456 Jodi 1 789 Bob 1 456 Bob 3 789 Joe 3 123 Joe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Group cells during sort | Excel Discussion (Misc queries) | |||
How do I sort a group of calculated cells in Excel? | Excel Worksheet Functions | |||
Trying to group cells so that I can sort the upper most cell with. | New Users to Excel | |||
How do i sort a group of cells from highest to lowest | Excel Discussion (Misc queries) | |||
How can I group a bunch of cells together, so I can sort by colum. | Excel Worksheet Functions |