| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you group together rows to remain intact while sorting? | New Users to Excel | |||
| How do I group multiple lines of excel info for easy sorting | New Users to Excel | |||
| Sorting by Group of Cells | Excel Discussion (Misc queries) | |||
| excel group sorting | Excel Discussion (Misc queries) | |||
| Automatic Sorting of a group of columns. | Excel Worksheet Functions | |||
Linear Mode
