How to refer to an Array in Excel dynamically
Imagine you want to refer to an array in Excel dynamically. You can do it by using a formula like this: It supposes that cells E1 and E2 contains the row and column number respectively for the start cell, and…