Median
Calculates the (numerical) median for all of the values in a list of values, ranges and/or lists.
Syntax
Median(param1, param2, ...)Mediane(param1, param2, ...)
param1 = first parameter in the value set (value, range, or list)
param2 = second parameter in the value set (value, range, or list)
... = nth parameter in the value set (value, range, or list)
Remarks
It is standard that, if none of the elements in the value set represents the median, the median returned will be the halfway point between the two extreme values of the sub-sets shared by the median.
This function accepts an unlimited number of parameters.
Any non-numerical values are ignored.
Examples
Median(1, 2) = 1.5Median(1, 2, 3) = 2Median(A1:B3) = median of all of the numerical values in the A1:B3 range