For this way to work, you will need to sort the original two column by the
team size (first column). Then set your new column to accumulate the counts
before knowing which was the 430th instance. After sorting, the median size
would be 5.

--
Daryl S


"Jim Thomlinson" wrote:

You are correct. By the time you have gone through the 6s you have just past
425 instances, so you would be 5 instances into 7 when you hit 430...
--
HTH...

Jim Thomlinson


"cabana_boy via OfficeKB.com" wrote:

Wouldn't the 430th instance actually be 7? Six ends at the 425th instance (if
my calculator is working correctly).

Jim Thomlinson wrote:
So when we add up all of the instances there are 860. So your median is at
the 430th instance. That is 6. Write a helper column function to accumulate
the total and look up the closest match to 430... use index match to do the
lookup...
Let me clarify, I'd like to avoid entering the formula in manually....this is
a "true" example of what I'm trying to convert, and would rather not enter
[quoted text clipped - 51 lines]
Thanks.
I n

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200912/1

.