Dynamic Skip?

4.68K viewsFormulas and Functions
0

Hi,

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

0

Hi,

I wanna know if there´s any possibility to have a mix row, between Inputs and Formulas, without the conditions “skip” or “in”.

I want a dynamic formula to skip all years but real, and keep it automatic trough the years

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