Sorting in group

  • Thread starter Thread starter daniellchiu via OfficeKB.com
  • Start date Start date
D

daniellchiu via OfficeKB.com

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!
 
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:
 
Hi

Insert a new row 1 and enter Original in A1, Letter in B1, Number in C1
In B2 enter
=IF(CODE(LEFT(A2))>63,LEFT(A2),B1)
in C2 enter
=IF(CODE(LEFT(A2))>63,--(MID(A2,2,30)),A2)
Copy B2:C2 down as far as required.

Mark columns A:C>Data>Sort>click my data has headers>Sort by>Letter
Ascending>Sort by>Number Ascending
 
Back
Top