Good stuff!

--
Biff
Microsoft Excel MVP


"Lori Miller" wrote in message
...
Yup, your description was a lot clearer.
I should do better as a former stats tutor <g.

I just noticed though your second example from earlier
takes the upper value of 53 instead of the lower one.
It looks like this is because the result of the PROB
calculation is rounded to just larger than 0.5 internally.

Maybe more consistent and easier to follow to use this
which does return the lower value of 37 in that case:

=LOOKUP(2,1/FREQUENCY(SUM(B3:B36)/2,SUMIF(A3:A36,"<="&A3:A36,B3:B36)),A3:A36)

You can learn two new things if you're lucky!