Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting multiple rows at once (including merged cells)
I would like to sort groups of rows without undoing all of the merged cells.
Each PO uses 4 rows. I want to assign a building order to tell production which one to build first. The first column (BO a.k.a. building order) is merged into groups of 4 cells (for each PO) The second column is merged for company name. i.e. BO / Company / Product Size _____________________________________ / / 2 x 8 2 / Zippo / 3 x 9 / / 4 x 6 / / 9 x 14 _____________________________________ / / 8 x 10 1 / Primetech / 2 x 9 / / 3 x 7 / / 5 x 9 _____________________________________ When I use the 'SORT' in the first column, it brings primetech to the top...but only the top row of the product size. I need it to bring up all 4. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting multiple rows at once (including merged cells)
Hi
AFAIK not possible with merged cells! -- Regards Frank Kabel Frankfurt, Germany Aaron wrote: I would like to sort groups of rows without undoing all of the merged cells. Each PO uses 4 rows. I want to assign a building order to tell production which one to build first. The first column (BO a.k.a. building order) is merged into groups of 4 cells (for each PO) The second column is merged for company name. i.e. BO / Company / Product Size _____________________________________ / / 2 x 8 2 / Zippo / 3 x 9 / / 4 x 6 / / 9 x 14 _____________________________________ / / 8 x 10 1 / Primetech / 2 x 9 / / 3 x 7 / / 5 x 9 _____________________________________ When I use the 'SORT' in the first column, it brings primetech to the top...but only the top row of the product size. I need it to bring up all 4. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting with Merged Cells | Excel Discussion (Misc queries) | |||
Seperate Merged Cells with multiple rows? | Excel Discussion (Misc queries) | |||
sorting merged cells | Excel Worksheet Functions | |||
identically size merged cells for sorting rows | Excel Discussion (Misc queries) | |||
Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions |