ExcelBanter - Sorting in group

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sorting in group (https://www.excelbanter.com/excel-discussion-misc-queries/168066-sorting-group.html)

Sorting in group

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

Sorting in group

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

Sorting in group

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:CDataSortclick my data has headersSort byLetter
AscendingSort byNumber Ascending
--

Regards
Roger Govier

"daniellchiu via OfficeKB.com" <u36625@uwe wrote in message
news:7c04d1a3e1bc9@uwe...
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