Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting two columns of merged cells
I have two columns of merged cells. two cells in each column are merged in
each row: ie A1 and B1 are merged into one cell, a2 and B2, etc. The next column is the same; C1 and D1 are merged, C2 and D2, etc. Is there any way I can sort these columns? I need a descending sort by col A and B. Im using Excel 2003 Hope this is clear. Jim |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting two columns of merged cells
Don't merge cells.
Look in the archives of this group for countless reasons why not; you've just found one of them. -- David Biddulph "bigjim" wrote in message ... I have two columns of merged cells. two cells in each column are merged in each row: ie A1 and B1 are merged into one cell, a2 and B2, etc. The next column is the same; C1 and D1 are merged, C2 and D2, etc. Is there any way I can sort these columns? I need a descending sort by col A and B. Im using Excel 2003 Hope this is clear. Jim |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting two columns of merged cells
HTH:
http://excel.tips.net/Pages/T002581_...ged_Cells.html Micky "bigjim" wrote: I have two columns of merged cells. two cells in each column are merged in each row: ie A1 and B1 are merged into one cell, a2 and B2, etc. The next column is the same; C1 and D1 are merged, C2 and D2, etc. Is there any way I can sort these columns? I need a descending sort by col A and B. Im using Excel 2003 Hope this is clear. Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting with merged cells | Excel Discussion (Misc queries) | |||
Sorting with Merged Cells | Excel Discussion (Misc queries) | |||
Sorting merged cells | Excel Worksheet Functions | |||
sorting merged cells | Excel Worksheet Functions | |||
Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions |