Column A: 1000 unique names

Column B: A number corresponding with each name in A

Column C: Same 1000 names as A (different order than A, since values in D have changed)

Column D: A number for each name from C (numbers have changed from B)

At the moment, A/B and C/D are sorted from largest to smallest.

I want to create column E with the same 1000 names, but sorted by the difference between the values corresponding with each name from columns B and D. That Difference will be in column F.

Some values have changed a lot, so a name at the top of the column A may be way down the list in column C.

What is the easiest way to do this?

Thank you