i'm trying to replicate in Nexel the following excel formula:
The objective is to obtain the row number of a range where a condition is met for the first time.
In the example attached i'm looking to find in the range (B2:B6) the first row where the value is ">1000" (A2), so the 4th.
I can't find the right syntax and unfortunately the "Nexel formulae" doesn't help.
I'm working with Board version 10.1.2