Forum Discussion
Solved
Sorting Scientific Notation, Alpha, Numeric, and Alphanumeric
Spent much time looking for a way to sort this data set (which is in an Excel worksheet table as part of a much larger dataset) such that it's in order from A to Z and of course all of the rows in th...
- Hi Hans,
As mentioned in my private message to you, I re-attempted the sort successfully on Excel for the web and another PC that is running a different build of Excel desktop. So it appears that the sort issue has something to do with the Excel desktop build on my other PC.
Thank you again for your time and expertise!
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Hi Hans,
Thanks for taking a look at this. The sample below is purely fictious, but somewhat representative of the full dataset. I don't see an option to attach this as file and not able to send a link for OneDrive, Google Drive, Dropbox, etc. Hopefully you can work with this sample. The sorting on the "Code" column in the table is the issue.
Description Code Inventory Qty. Cost Gloves, Black - Small 011 28 $3.99 Gloves, Black - Medium 023 40 $4.99 Gloves, Black - Large 034 29 $5.99 Gloves, Brown - Small 7E1 310 $3.99 Gloves, Brown - Medium 085 11 $4.99 Gloves, Brown - Large 107 54 $5.99 Gloves, Blue - Small 229 23 $3.99 Gloves, Blue - Medium 270 54 $4.99 Gloves, Blue - Large 360 71 $5.99 Gloves, Red - Small 420 94 $3.99 Gloves, Red - Medium 501 5 $4.99 Gloves, Red - Large 627 44 $5.99 Gloves, White - Small 901 63 $3.99 Gloves, White - Medium 09G 741 $4.99 Gloves, White - Large 0Z5 45 $5.99 Mittens - Orange 39Z 55 $2.99 Mittens - Red 3G5 9 $2.99 Mittens - Blue 41N 72 $2.99 Mittens - Green 55Q 34 $2.99 Mittens - Yellow 6DZ 45 $2.99 Mittens - Black 7FF 16 $2.99 Mittens - Purple 82A 112 $2.99 Mittens - Pink 98E 33 $2.99 Mittens - White 99R 4 $2.99 I pasted your sample data into an Excel sheet formatted as text, then sorted on the Code column:
Perhaps you can attach a sample workbook in a private message to me (click on my user picture)
- Hi Hans,
As mentioned in my private message to you, I re-attempted the sort successfully on Excel for the web and another PC that is running a different build of Excel desktop. So it appears that the sort issue has something to do with the Excel desktop build on my other PC.
Thank you again for your time and expertise!