b 111
b 2222
b 33333
a 444
a 5555

c 77
c 88
c 99

put letters as i did then sort by column A and B

"daniellchiu via OfficeKB.com" skrev:

How do sort this

b 111
2222
33333
a 444
5555

c 77
88
99

become like this

a 444
5555
b 111
2222
33333
c 77
88
99

thanks!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200712/1