LinkBack URL
About LinkBacks
Hi, I sorted my data really quick trying to see something and now can't put it back in its original order? Help? Ty.
Hi, I sorted my data really quick trying to see something and now can't put it back in its original order? Help? Ty.
Either use Undo, or close the Workbook and DO NOT save changes.
Great. Months of work ruined …
Not sure if there is a good answer for you.
From this vantage it isn't possible to determine what the original order was.
If you make a mistake with sorting data, you can quickly change it back with the "control z" combination.
If your data didn't have a specific sort order to begin with, you most likely will not get it back in that order.
I feel that the biggest mistake with using Sort is if all of the applicable columns don't have the filter selected for them.
If all the applicable columns don't have the filter assigned, the data will be completely out of wack if you hit the sort button.
Wish I could give better answer and advise.
If you don't save after sorting, the file reverts back to how it was when opened. If you right click on the file in Windows Explorer and click on Previous Versions, you may be fortunate and have a copy of the file before you sorted and saved.
If the workbook hasn't been saved use the undo button on the Quick Access Toolbar or Ctrl + Z to unsort. You can also use the down arrow next to the Undo button and you will be presented with a list of edits showing the latest edits at the top of the list. Select the number of undo actions that you want and left click and those actions will be undone.
To ensure that you can unsort your data at any time, number the records consecutively in a column next to the data. Include the numbers in any sort that you do. Then, when you want to unsort, select all the data including the column of consecutive numbers and then sort on the column of consecutive numbers. This will return the data to the original order.
Last edited by newdoverman; 03-14-2016 at 07:46 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Can I send anyone the file to see if they could put it back toegther?
Unless you haven't saved the file for months, you can't have lost months of work. The most you can have lost is any work you did between opening the file and sorting it. And that would be your penance for not making backup copies.
How can anyone else "put it back together"? You know what it looked like and you can't.
If it's not in its original order, it's all jumbled up and not of much use to me … therefore ruined.
Upload the file here. Zip it if over 1MB. We may only help if there was some logic to the original order of the data.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).
Last edited by newdoverman; 03-14-2016 at 08:04 PM.
How is anyone else supposed to know what the unsorted data should look like? They'd probably have more success unscrambling an omelette.
My recommendation if you've already saved the sorted file: restore the most recent unsorted copy from your backups.
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
It's easy to understand what order I previously had it in! The first way it is ordered is by date, the next is by time—those things you can get back by merely sorting those columns. But for each game, there are two rows, one for each team. The away team goes first, the home second. But the only way you can order the teams after getting the date and time back in order is alphabetically. I inserted a "before sheet" of what it used to look like using a small sample.
In order to 'un-sort' this, you have to re-sort it 3 times in a particular order.
1. Sort column H alphabetical (A->Z) -- This puts all the away games first, and the home games last.
2. Then, sort column B from smallest to largest -- This re-sorts by time (but the away-first, home-second is preserved).
3. Finally, sort by column A from smallest to largest -- This re-sorts by date (but the effect of the previous two sorts is preserved).
Is this what you want?
(see attached for my sample output)
Last edited by eibi; 03-14-2016 at 08:27 PM.
No. I need it to alternate away home away home away home for each corresponding game. Not all the aways in one section and all the homes in another.
Did you look at the attachment?
Last edited by eibi; 03-14-2016 at 08:32 PM.
Yes I did. Why do you ask?
It does alternate away home away home...
idk.png
If you look at 12/25, it's perfect because all the games are at different times. But anything beyond that on nights where there are 4 games at the same time, everything becomes jumbled.
Each game should take up two rows … the only thing is each row used to be next to each other.
Yikes -- I see...When there are multiple games at the same time, do you have a preferred order that they should be listed? That is to say -- does it matter which game comes first?
Last edited by eibi; 03-14-2016 at 10:58 PM.
Perhaps a single three-tiered sort: by date; then by time; then by home/away.
Sorting the columns in the order C, D, B, A gets close but I think that some of the columns had been sorted without sorting the rest of the data as it appears that some teams are shown as away in two different places at the same date and time.
25/12/2011 seems to work ok but the rest.....
That, then, is a problem with the data, not with the re-sorting logic.Originally Posted by newdoverman
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks