Attached is work book 5.
What I am trying to do now is:
The ranking in column C of 10 numbers (this can be as high as 15 numbers)
10
03
06
09
04
01
05
08
07
02
The values in column E:
05
-08
03
-10
07
07
-15
8
0
-11
I am trying to get the corresponding cell number in column E to line up next to its partner in column C .
Example:
Column C states that cell number 10 is the highest ranked value.
I would like to get the value of cell number 10 in column E to be listed in column D cell 1.
10 ... - 11
03 ... 03
06 ... 07
09 ... 00
04 ... - 10
01 ... 05
05 ... 07
08 ... 08
07 ... - 15
02 ... - 08
Bookmarks