Assume A1 to A10 have value of 11 12 13 14 15 16 17 18 19 & 20
and B1 to B10 have value of 9 8 7 6 5 4 3 2 1 0
Need formula or VBA - while giving reference cell value, it should be to count respective downwards cell value.
If i give A4 as 14 And A9 as 19, formula...