Results 1 to 2 of 2

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Location
    Victoria, Canada
    Posts
    121
    Articles
    0
    Excel Version
    Microsoft Excel 2013

Posting Permissions

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