Sorting cells with coordinates to match in different columns

[Bjorn85]

Hello,

Data1 x y z Data2 x y z
1 1 2 0,2 1 1 -2 0,1
2 1 -2 0,1 2 1 2 0,2
3 2 -3 -0,1 3 5 1 -0,5
4 5 1 -0,5 4 0,5 3 -0,1
5 0,5 3 -0,1 5 2 -3 -0,1

Now what I want to do is to match the x,y,z, coordinates to find out which Data1 ID corresponds to which Data2 ID, i.e. I want to sort it like this

Data1 x y z Data2 x y z
5 0,5 3 -0,1 4 0,5 3 -0,1
2 1 -2 0,1 1 1 -2 0,1
1 1 2 0,2 2 1 2 0,2
3 2 -3 -0,1 5 2 -3 -0,1
4 5 1 -0,5 3 5 1 -0,5

Any ideas on how to do this? Sorting just operates on one column, so I can sort it with respect to i,e, x-coordinate, but not the other columns.

Thanks

Best regards
Björn

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

[Bjorn85]

I did create one, but couldnt attach it for some reason. Trying again now.

[JohnTopley]

Select the data including headings>>Custom Sort>>by Field X .. smallest to largest ..Add Field Y .. Smallest to largest

[Bjorn85]

Select the data including headings>>Custom Sort>>by Field X .. smallest to largest ..Add Field Y .. Smallest to largest

That is what I first tried to do, but still doesn't seem to work...but I am having a thought it may be due to roundoff errors from the software producing the scalar fields. But in general, sorting it like that, should work right?

[JohnTopley]

See attached.

[Bjorn85]

Thanks. It seems that the error lies in the data points. I need to figure out a different way to do this.