Dynamic Skip?

4.67K 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


Any update to this question? I know it’s four years old but it’s a worthwhile question. I find myself constantly wishing Quantrix had this capability too. Being able to manually override calculated values would make my models so much more user-friendly (since people are used to doing just that in Excel – e.g. as each month’s Actuals are known, one just manually types in the Actuals in place of the formula that was previously calculating the Budget values).

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