Kindly refer attached screenshot. Am trying to figure how does one populate the boxed column with the value in the cell (1,414). I am already able to do something by looking up a SYS table I constructed but the problem is I can't seem to figure out the right formula to use which should be to pick up the value 1,414 which corresponds to Rank 20 in the Rank column.
Any ideas much appreciated.
Kind regards,
Clarence
Solved! Go to Solution.