| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alpha sorting (with a twist...?)
Hi, I've followed MS instructions for alpha sorting (e.g. helper column w/
=text(e5,"###") ) to no help. I think that works only when the value in the column begins with a number. My data can begin w/ a number or alpha character. Here's an example of my data: 1 2 3 4 A1 A10 5 6 7 8 A11 A12 A2 A3 A4 A5 9 10 11 12 A6 A7 A8 A9 B1 B10 B11 B12 B2 B3 B4 B5 B6 B7 B8 B9 And here's how I want it sorted... 1 2 3 4 5 6 7 8 9 10 11 12 A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 A11 A12 B1 B2 B3 B4 B5 B6 B7 B8 B9 B10 B11 B12 But it keeps coming out like this: 1 2 3 4 5 6 7 8 9 10 11 12 A1 A10 A11 A12 A2 A3 A4 A5 A6 A7 A8 A9 B1 B10 B11 B12 B2 B3 B4 B5 B6 B7 B8 B9 This is the second column of a three-column sort. Suggestions? Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Alpha-Numeric Values | Charts and Charting in Excel | |||
| Sorting alpha in two columns | Excel Discussion (Misc queries) | |||
| Sorting Alpha Numeric | Excel Discussion (Misc queries) | |||
| Alpha-Numeric Sorting | Excel Discussion (Misc queries) | |||
| Sorting by Date (With a Twist) | Excel Discussion (Misc queries) | |||
Threaded Mode
