Hi,
I have a complicated Offset which is supposed to reference a row of 52 columns based on a reference cell, which will then be used for other calculations.
After i type in the offset in my formula, is there a way to check that it is referencing the correct range?
One method I know would be to make a named range of the offset, then check the location of the named range.. However its a formula that gets copied down to reference other key cells to change the offset, so that would only work for 1 row, and I'd like to check that its working on all rows instead of just one. (every row will have a different offset range).
Any other ideas?
I am aware offset is a volatile function and the con's associated.
Thanks in advance!
I have a complicated Offset which is supposed to reference a row of 52 columns based on a reference cell, which will then be used for other calculations.
After i type in the offset in my formula, is there a way to check that it is referencing the correct range?
One method I know would be to make a named range of the offset, then check the location of the named range.. However its a formula that gets copied down to reference other key cells to change the offset, so that would only work for 1 row, and I'd like to check that its working on all rows instead of just one. (every row will have a different offset range).
Any other ideas?
I am aware offset is a volatile function and the con's associated.
Thanks in advance!