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?