Is there a way to find the order of how the data is put in origina

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
I'm not aware of a way if it was resorted before it was sent to you.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PowerPoint Powerpoint image ordering on a single slide 3
Function in Excel to count and list number of entries of text valuesin a row. 2
Can I find the last value in a column of cells? 4
finding & sorting unqiue names list 6
Is there a way... 5
Access Default Microsoft Access Order Entry database issue 0
Is there an easy way to find/display merged cells in excel 2
Is there a way to change the color 3

Back
Top