Finding a subset within a column, and then the min of that subset
Dear all,
I am trying to create a formula that will find a set of numbers within a column, and then find the 'min' value of that specific set. For example, in the data attached/below, I want to find a min amplitude between each time interval written across the top. So an example of this would be the 'min' amplitude between time intervals 0 and 10 would be -33.26416, and the min amplitude between times 11 and 20 would be 0.610.
I need to do this with about 100,000 amplitude data points which are between about 600 time intervals. I have already tried pulling out the amplitudes within a specific time interval to the columns underneath the time intervals, and then getting a min value for each column, but I have way too much data for this to realistically work.
Could anyone please help me with a formula that does not need to be dragged across an area of 100,000 by 600?
Any help on this would be very much appreciated.
Timothy
Attachment | Size |
---|---|
Finding a specific set of data, and then the min value within this set.xlsx | 15.26 KB |
Recent comments
5 years 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago