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

P

Phil

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.
 
G

Gord Dibben

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
 
Top