One of the shortcomings of Microsoft Excel is that you cannot easily obtain the median for several different variables. Mystery solved. I recently came across this link to step you through a formula that – at first glance – may look complicated. But it’s really not too difficult to recreate.

One note: be sure to exit the formula cell with this command – control/shift/return. That creates an array function.