I am trying to do dynamic formulae creation and have successfully done in the past, but I am facing a very strange issue whereby using the ROW() formula within the INDIRECT() formula breaks it and it gives a #VALUE error.
If I enter 3 values in column A as below:
A1: 1
A2: 2
A3: 3
I can then...