Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello,
I have received a spreadsheet that has been re-sorted, and now I don't know what the original order was of the entries. Is there a way to find this out? TIA for your replies. Phil. |
#2
![]() |
|||
|
|||
![]()
I'm not aware of a way if it was resorted before it was sent to you.
"Phil" wrote in message ... Hello, I have received a spreadsheet that has been re-sorted, and now I don't know what the original order was of the entries. Is there a way to find this out? TIA for your replies. Phil. |
#3
![]() |
|||
|
|||
![]()
Phil
No. Unless there was a key column on which the sort took place and you could derive the original order from that. Some people like to place sequential numbers down a spare column before sorting so's they can always return to the original order using that column for re-sorting. Perhaps the originator of the worsheet has a copy of the unsorted sheet that could be sent? Gord Dibben Excel MVP On Sun, 23 Oct 2005 15:10:02 -0700, "Phil" wrote: Hello, I have received a spreadsheet that has been re-sorted, and now I don't know what the original order was of the entries. Is there a way to find this out? TIA for your replies. Phil. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
data from one sheet to several in sequential order! | New Users to Excel | |||
How do I set the order of calculation of Data Tables in Excel? | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Find and replace data in an Excel chart object | Charts and Charting in Excel | |||
Help with data not getting plotted | Charts and Charting in Excel |