Forum Discussion
How do I find the median of a selected column of values within a worksheet
Is it possible for you to upload a sample (devoid of actual names or other confidential info)? Otherwise, all you'll get is very general and it sounds very much like you would appreciate specific help.
Interested, yes. Able to do it? Sigh...afraid not. I thought the Pivot Table would do it, but it's limited to Average, and so far as I could tell there's no readily available calculation for Median among the Pivot Table options, which surprises me. There are Standard Deviation calcs, but no Median.
So let's see if somebody else can finish it as you want it. Here's the Pivot Table, just so you can see what it does. FWIW, it's a very easy way to summarize data, and rarely fails to satisfy. This time it does fail.
P.S. Ah,, I see mtarler has done it.
