If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can you split the column into 4 seperate columns using data ---text to columns
(format all cells as text beforehand so you dont lose leading 0's)? Then Select entire region and sort by Col D then other criteria "retman" wrote in message ... : Hello, : Below you can find an example of my worksheet: : DC 00 03 20 : FE 06 55 20 : BD 09 29 40 : CT 08 41 70 : GT 09 92 80 : In this example, you see the sort as I want it (right-to-left and : top-to-bottom). But how can I let Excel do this sort? Now I'm first sorting : all the numbers by hand. |
#2
|
|||
|
|||
How to sort a column in reverse (right-to-left)
Hello,
Below you can find an example of my worksheet: DC 00 03 20 FE 06 55 20 BD 09 29 40 CT 08 41 70 GT 09 92 80 In this example, you see the sort as I want it (right-to-left and top-to-bottom). But how can I let Excel do this sort? Now I'm first sorting all the numbers by hand. |
#3
|
|||
|
|||
-----Original Message----- Hello, Below you can find an example of my worksheet: DC 00 03 20 FE 06 55 20 BD 09 29 40 CT 08 41 70 GT 09 92 80 In this example, you see the sort as I want it (right-to- left and top-to-bottom). But how can I let Excel do this sort? Now I'm first sorting all the numbers by hand. . You could highlight the cells and use DataSort and then select which columns you wish to sort by. HTH |
#4
|
|||
|
|||
I don't believe you can sort both in one operation. Select your cells, then
Data|Sort and select options. You can then choose "Sort left to right" instead of "Sort top to bottom". Select ascending or descending depending on the order you want. Then Sort it again going top to bottom (normal). "retman" wrote: Hello, Below you can find an example of my worksheet: DC 00 03 20 FE 06 55 20 BD 09 29 40 CT 08 41 70 GT 09 92 80 In this example, you see the sort as I want it (right-to-left and top-to-bottom). But how can I let Excel do this sort? Now I'm first sorting all the numbers by hand. |
#5
|
|||
|
|||
With your data in A15, select the entire range. Click on Data|Sort, select
sort by Col D. In the next sort option, select sort by Col C, and click on OK, that's it " wrote: -----Original Message----- Hello, Below you can find an example of my worksheet: DC 00 03 20 FE 06 55 20 BD 09 29 40 CT 08 41 70 GT 09 92 80 In this example, you see the sort as I want it (right-to- left and top-to-bottom). But how can I let Excel do this sort? Now I'm first sorting all the numbers by hand. . You could highlight the cells and use DataSort and then select which columns you wish to sort by. HTH |
#6
|
|||
|
|||
I'm sorry, but I forgot to mention that these 'numbers' are all in one cell,
so "DC 00 03 20" is in one cell. And another thing is, that I want to have it sorted that you first see all the 'numbers' which end on 0, after that, 1 etc. Like this: DC03210 FE65520 BD92940 CT84170 GT99280 SE38734 FT01484 DR04567 RD31798 I hope you know how to tackle this one! Thnx! "retman" wrote: Hello, Below you can find an example of my worksheet: DC 00 03 20 FE 06 55 20 BD 09 29 40 CT 08 41 70 GT 09 92 80 In this example, you see the sort as I want it (right-to-left and top-to-bottom). But how can I let Excel do this sort? Now I'm first sorting all the numbers by hand. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I sort by row instead of by column? | PercivalMound | Worksheet Functions | 7 | August 28th, 2006 10:41 PM |
outlook: print work week calendar w/sunday in 1st left column | frog13 | Calendar | 1 | November 25th, 2004 03:34 AM |
How can I sort an entire spreadsheet from a list | prod sorter | Worksheet Functions | 4 | November 17th, 2004 03:43 AM |
Column E cell contents added into Column D contents (not overwriting data but mixing) | creativetechguy | General Discussion | 2 | August 5th, 2004 07:32 PM |