View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sal Sal is offline
external usenet poster
 
Posts: 84
Default Sorting with merged cells

Greetings,

Is there a way to sort with merged cells (2 rows each with column A) with
unmerged cells (Column B). I have the following:
c 3
1
a 2
3
b 2
1
e 1
2
a 3
1
b 3
2
a 1
2
b 1
3

I would like to sort by column A then by column B so that the sort comes out
as follows:
a 1
2
a 1
3
a 2
3
b 1
2
b 1
3
b 2
3
c 1
3
e 1
2

Is there a way to do this?

Thanks,
--
SAL