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