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


Hmmm – INDIRECT in a Skip will certainly throw a syntax error.

Sometimes if you post a sample model that will help visualize the scenario you are describing. There may be a different approach the forum community can consider.

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