In my spreadsheet I have a list of names in colA. In this list there are merged cells. The number of cells in each grouping varies. Then in colC I have some other merged cells. There is never merged cells in colC that go across merged cells in ColA. All the rows merged in ColA might not be merged in colC. When I sort this data I want them to be sorted on ColA and the block of rows corresponding to the merged cells to be sorted as a block. Is this even possible? I have tried making the groupings in ColC the same as the groupings in ColA and I still get the message that all merged cells must be the same size.