Syntax:
MEDIAN( list )
Returns the median value in the list.
list may be a range of cells, an array, or a comma-separated list of values (which may contain cell references and also ranges of cells as one or more of its elements).
If there is an even number of entries in the list, the arithmetic mean of the two middle values is returned.
It is not assumed that the data is sorted.
Revisions:
Starting with 2.00, this function will accept a list of parameters. Before this, it only accepted an array of data.