Hi there,
I am tracking smallest margins of victory in a fantasy football league. In a row for each week I have a series of positive (for points won by) and negative numbers (for points lost by).
I can't figure out the formula to calculate the 2nd smallest number greater than zero (and subsequently the 3rd and 4th smallest).
One of my ranges is from F509:V:509 for example (Spanning 17 weeks of the season).
Here's what I have to figure out my first number greater than zero: {=MIN(IF(F509:V509<0.01,"",F509:V509))} I have used .01 as we don't use anything smaller than that in our league.
Can anyone help with this?
Thanks,
Damian
Bookmarks