Issues with Excel file sorting

  • Thread starter Thread starter JulesB
  • Start date Start date
J

JulesB

I'm having an issue with Excel. I have an excel file which I failed to add
an "as entered" column to. Then I handed off the file to another user to
edit one of the columns (and fields in the column). Somehow various
sorts/filters done on the file ultimately changed the order of the file and I
can't get it back to the orginal order as entered.

Is there a way I can compare the initial file (which I saved off) and the
second file and get the second file reordered to the initial entered sequence?

Any help would be SOOOOO appreciated.

Thanks!

Jules
 
Do you have a unique key that will appear in a single column in both worksheets?

If yes, then maybe...

You could add that column in the new file and put a formula like:

=match(x1,sheet2!x:x,0)

Where x holds the unique key in the new worksheet and sheet2 column X holds the
unique key in the old worksheet.

Then drag it down as far as you need.

The formula will return a number (the row number) of the first match (that's why
the matching value needs to be unique). If there is no match (new records???),
then you'll get an error returned.

Then sort by this column (and move the error rows to where you want them)
 
Thanks Dave, I'll give this a try!

Dave Peterson said:
Do you have a unique key that will appear in a single column in both worksheets?

If yes, then maybe...

You could add that column in the new file and put a formula like:

=match(x1,sheet2!x:x,0)

Where x holds the unique key in the new worksheet and sheet2 column X holds the
unique key in the old worksheet.

Then drag it down as far as you need.

The formula will return a number (the row number) of the first match (that's why
the matching value needs to be unique). If there is no match (new records???),
then you'll get an error returned.

Then sort by this column (and move the error rows to where you want them)
Click to expand...
 
Back
Top