Dynamic Skip?

4.68K viewsFormulas and Functions


I’m wondering if there is any way to set the range to be skiped over (when using the Skip operation) dynamically? I was hoping I might be able to set the range with Indirect – ie:

Well Name = Exp Well Summary::Well Name Skip Indirect(“ExpWellID[“&Counta(Exp Well Summary::Well Name)&”] .. ExpWellID[LAST]”)

But I get a syntax error when trying to use Indirect with Skip. Is there any other way to do this?

Many thanks


Hi – You could like the Year category to a new matrix, then set a flag to indicate when the calculations should occur for Loan and Depreciation.

Then you can use this flag in an IF or SWITCH function, and avoid having to use a SKIP.

You can then simply change the flags to adjust the calculation.

Please see attached.

You are viewing 1 out of 7 answers, click here to view all answers.