picking points [SOLVED]

    I am trying to have a formula pick the maximum force within a positional range.
    min position of .3 and max of 1.0
    I tried vlookup but my data isn't sorted and I keep getting errors. It seems like an easy enough concept to me, but it is out of my grasp.


    Thanks
    Mike

    with the data as in you attached workbook:


    =MAX(IF((A2:A2413>=0.3)*(A2:A2413<=1),B2:B2413))


    ...returns 279.04. The formula needs to be array entered using control + shift + enter, not just enter. You could also consider using dmax() - check it out in the help file.


    paddy

    New issue, I am using modified versions of Paddyd's formula to pick other points.
    I am trying to get the lowest point just before the small dip and the sharp climb to the peaks. I can currently only figure out how to get the low point of the small dip. I figure offsetting up 20rows from the dip would give me the data I need. the small dip in this data set is in B1603. so I would want the to have it come up with b1583


    =MIN(IF(($A$2:$A$2413<=0.6)*($A$2:$A$2413>=0.1),$B$2:$B$2413)

    If anybody was working on this thank you. I came up with a way to make it work. It may be archaic, but i'm still learning


    this is what I came up with
    =INDEX(A:B,(MATCH((MIN(IF((A2:A2413<=0.3)*(A2:A2413>=0),B2:B2413))),B2:B2413,0))-20,2)


    Mike

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login