MEDIAN

Finds median value of a list of numbers

MEDIAN( value 1, [value 2 ...] )

Returns the median of a list of numbers, ignoring any blank values.

Arguments

Argument	Description
value 1	numeric column or value
[value 2...]	Optional. Column(s) to be included in the calculation; will output a row-wise calculation when this argument is provided.

Output

Numerical median of input values

Example