retrieving values between 2 defined limits in experimetal data series

[uriel78]

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 value>1 ,
or better, the step "i" between steps "i-1" and "i+1" where i-1<1 and i+1>1

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

TIA for evey help

 

[JE McGimpsey]

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?

 

[uriel78]

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?

thank you for your answer.
IT isn't possible, they are increasing values (and positive,too) each one
smaller than its follower

 

[uriel78]

in addition, values are results of experimental data, it's rather impossible
that generic "i" values is =1. That's the reasons for which I need to know
when (=at which step) the generic "i" value in his own series switches from
0,... to 1,... (the condition I said is "i" so that i-"1<1 and i+1>1")

 

[JE McGimpsey]

Don't know what type of experiment you're recording, but since your
example included values to 2 decimal places, I'd think it could easily
be the case that 1,00 is just as likely as 1,01 or 0,99 or any other
value.

 

[uriel78]

Don't know what type of experiment you're recording, but since your
example included values to 2 decimal places, I'd think it could easily
be the case that 1,00 is just as likely as 1,01 or 0,99 or any other
value.

I don't understand...
my data values (let's call them "output") refer to a parameter related to
the behaviour of an element subjected to increasing load; they could be
considered as the "level" of stress inducted on the element. When "output"=1
my element becomes unstable...but I can still increase load until
"output"=10. For this reason, I want to know at which step output=1, or
better, when "output" passes through 0,... to 1,...