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.

I'm not aware of a way if it was resorted before it was sent to you.

"Phil" <Phil@discussions.microsoft.com> wrote in message
news:461EED31-4EBC-46DC-B5C5-3575ACB05025@microsoft.com...
> 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.

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" <Phil@discussions.microsoft.com>
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.