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


Thanks for your solution of IF and SWITCH functions!
I’m agree avoid having to use a SKIP in this case but I think it’s better if we can use SKIP with CLAUSE or CONDITION :)

Please help me about [b:ihr8d25n]automatic creating[/b:ihr8d25n] the number of Items of Year Category when I [b:ihr8d25n]change[/b:ihr8d25n] “Total operation years”?

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