ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   sorting two columns of merged cells (https://www.excelbanter.com/excel-discussion-misc-queries/260604-sorting-two-columns-merged-cells.html)

bigjim

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

David Biddulph[_2_]

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




מיכאל (מיקי) אבידן

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



All times are GMT +1. The time now is 01:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com