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

AttachmentSize
Finding a specific set of data, and then the min value within this set.xlsx15.26 KB