retrieving values between 2 defined limits in experimetal data series
 

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

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

"JE McGimpsey" ha scritto nel messaggio
...
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

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+11")

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.




In article ,
"uriel78" wrote:

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+11")

"JE McGimpsey" ha scritto nel messaggio
...
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,...