Sort problem
Sort error.jpg
So, as per the attached pic you can see my issue.
This is only part of a much larger spreadsheet, so manual manipulation is a no-go.
I wonder if Excel can even sort this.....no-one seems to thinks so, they think I have to remove the hyphen!
Then my numbers will be corrupted.
Any thought anyone?
Hello there,
What is the highest number you have on your worksheet?
Thanks!
There's only one thing for it. Let us see your workbook or representative sample, not a picture. Something to work with please.
If I helped, please don't forget to add to my reputation. (click on the star below the post)
If the problem is solved, please: Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved.
Failure is not falling down but refusing to get up.
1014-11325
603-10762
1014-11315
813-10361
293-11074
1021-11027
443-10365
Raw data
Sorry, can't see a way to attach a spreadsheet!?
Highest number will be xxxx-xxxxx
Lowest number will be xxx-xxxxx
Last edited by Infastsalmon; 05-22-2012 at 06:34 AM. Reason: edit
Select the "Go advanced" button to the bottom right.
Scroll down to "Manage attachments" Click "Add files" Click "Select files" Locate and select your file.
Follow instructions that follow.
You could use the Text to columns function. If all date is in col A select Col a the text to columns under Data < Data Tools on ribbon. Select Radio button "Delimited" Other - enter dash. Next brings up Format options which here will default to general which is numbers. Finish. This will separate the data into A & B columns.
Now sort by column A and in column C input =A1&"-"&B1 which now gives your original data in the form you require.
I couldn't figure out a way to do it with a formula but I'm sure it can be done. I was stumped by the three or four digits before the dash.
I recorded a macro
Please Login or Register to view this content.
Last edited by Russell Dawson; 05-22-2012 at 07:33 AM.
Here is another option for you.
Thanks!
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks