Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |