G'day Excel Forum
I was wondering if someone might be able to help me modify a function.
I've been struggling with a frustrating problem for months now and consistently failed to find the problem, I think now at long last I've figured out that the culprit is the volatile OFFSET function in 2 of my equations.
To see if this is indeed the case I'm attempting to modify the equations in H3 and H4 (columns F and G respectively of the attached spreadsheet) such that they function as they do now (and importantly still use the named ranges to do so) however don't rely on the OFFSET function or any other volatile functions.
I've read around online and played around with the equation a bit but I haven't been able to see a clear way of replacing the OFFSET function in these equations.
Can anyone help me out on this one?
Regards
MattRNR
Bookmarks