Using INDIRECT() excel function to read R1C1 type cell references.
0
The indirect function is useful in the way that it returns reference to range. These references are spontaneously evaluated to display their contents. We can use either A1 or R1C1 style of referencing with INDIRECT() function.
0
The indirect function is useful in the way that it returns reference to range. These references are spontaneously evaluated to display their contents. We can use either A1 or R1C1 style of referencing with INDIRECT() function.