Row & column portions of a cell as variables
Hello,
Is it possible for me to make the column as well as the row portion of a
reference cell variable?
Example- If the reference is to cell B4, can I make "B" as a variable using
a formula as well as make "4" as a variable using a formula?
Please advise.
Thank you.
|