Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Phil
 
Posts: n/a
Default Is there a way to find the order of how the data is put in origina

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   Report Post  
Barb Reinhardt
 
Posts: n/a
Default Is there a way to find the order of how the data is put in origina

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   Report Post  
Gord Dibben
 
Posts: n/a
Default Is there a way to find the order of how the data is put in origina

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
data from one sheet to several in sequential order! firecord New Users to Excel 6 June 22nd 05 05:10 PM
How do I set the order of calculation of Data Tables in Excel? Charles Easton Excel Worksheet Functions 1 April 30th 05 10:35 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
Find and replace data in an Excel chart object Cawen Charts and Charting in Excel 2 March 31st 05 06:47 PM
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 05:15 PM


All times are GMT +1. The time now is 05:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"