One way:

If E1 is in column A:

=MATCH(1,A:A,TRUE)


No sure I understand your last criterion. Is it guaranteed that there
will be an i for which (i-1)<1 and (i+1)1? In other words, is it
possible that you could have something like

0,8; 0,9; 1,0; 1,0; 1,1

for which there is no solution?

In article ,
"uriel78" wrote:

I've got several columns of data; each columns refers to one element. Far
each elements the arrays are experimental values I call them "steps"(about
100 arrays for each element)

For every element ,i want to automatically check when values in array exceed
1


Example: for two elements

step E1 E2
1 0,23 0,8
2 0,56 0,87
3 1,02 0,90
4 1,89 0,91
5 3 0,98
..

70 30 1,2
..
100 54,1 56,5


I want to know, for each element (=column) the FIRST step at which value1 ,
or better, the step "i" between steps "i-1" and "i+1" where i-1<1 and i+11

The result would be sthg as
Step
E1 3
E2 69
E3 12
E4 36
.. ...

TIA for evey help