Ordering one table by the rules from another table

Hi, OP here. The original file was incorrect (my bad!), so I fixed it.

I've attempted solving this problem myself, but I did't get too far with it. Here is what I have now.

Here the red table lists the new positions of the entries in the green table. So that to get a new green table the old one should rearrange itself in the way listed in the red one. I've mistakenly used the LARGE function to get there (blue table), but the logic was flawed.

OK,

I hope we're not going round in circles here, but your new green table in N1:Q9 now agrees with the table I gave you in the workbook I attached originally, in E13:H21.

i.e. I queried whether your original table was correct and you agreed it wasn't and you had made a mistake. I believe that this means that my first solution was correct. Do you agree now.

Originally Posted by sulin360

Sorry, I missed it completely!

The solution almost works, however the formula produces anomalies when it deals with two ordering possibilities. E.g. if you look at rows 8 and 20 the solution is 50-67<->44-86 (where 67 and 44 are interchangeable), but the formula results in double 67s, which is not in the original data.

Hi,

OK, here's a mod which now picks up and allows for there being duplicate values in a row.