Sort data is same other as excisting data

[louvaek]

Hey experts,

I have a sorting problem
In my first sheet, I have this data

32AA400
32AA303
32AZ555
32BE444
32YU883

This in one column, and it's sorted in the way i want it to be (so manually sorted)

In my second sheet, I have this data:

32YU883 street ID 1
32YU883 street ID 4
32YU883 street ID 9
32YU883 street ID 10
32AA303 street ID 2
32AA303 street ID 4
32BE444 street ID 99
32AA400 street ID 44
32AA400 street ID 2
32AA400 street ID 1
32AZ555 street ID 7
32AZ555 street ID 42

Now I want to sort the data in my second sheet, in the same order as the data in the first sheet, like this:

32AA400 street ID 44
32AA400 street ID 2
32AA400 street ID 1
32AA303 street ID 2
32AA303 street ID 4
32AZ555 street ID 7
32AZ555 street ID 42
32BE444 street ID 99
32YU883 street ID 1
32YU883 street ID 4
32YU883 street ID 9
32YU883 street ID 10

Can I do this with a formula, or is there a sorting option in excel to complete this task? Just don't know where to start ...

 

[Ganjin]

if you are using excel 2007:
http://office.microsoft.com/en-us/e...for-sorting-and-filling-data-HA010222142.aspx

follow the instructions for creating a custom list,
then use a custom sort and set the order to the custom list you created.
hope that helps =)