| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sorting Issue (Mixde Fields)
I have an issue where I need to sort a worksheet based on a field (Bin
Location)that is sorting as seen below... 1A1 1A20 1A21 1A22 1A3 1A4 How can I get Excel to sort it the following way... 1A1 1A3 1A4 1A20 1A21 1A22 Please help.... I need to get this figured out today. I appreciate any responses. Thanks, Jonathan G. |
|
#2
|
|||
|
|||
|
One way: add a column showing the length of the column you want to sort, then
sort using the new column then the "real" column. "Jonathan G." wrote: I have an issue where I need to sort a worksheet based on a field (Bin Location)that is sorting as seen below... 1A1 1A20 1A21 1A22 1A3 1A4 How can I get Excel to sort it the following way... 1A1 1A3 1A4 1A20 1A21 1A22 Please help.... I need to get this figured out today. I appreciate any responses. Thanks, Jonathan G. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| An issue when sorting in excel PivotTable | Excel Discussion (Misc queries) | |||
| sorting issue - help | Excel Discussion (Misc queries) | |||
| Sorting blocks of data or named fields? | New Users to Excel | |||
| Sorting Spreadsheet with Merged Fields | Excel Discussion (Misc queries) | |||
| Sorting Merged Sum Fields | Excel Worksheet Functions | |||
Linear Mode
