# Thread: Finding a subset within a column, and then the min of that subset

1. ## 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, 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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•