MEDIAN function
MEDIAN returns the median (middle) value in the list.
Syntax
MEDIAN(number 1,number 2, ...number 255.)
MEDIAN logically ranks the numbers (lowest to highest). If given an odd number of values, MEDIAN returns the middle value. If given an even number of values, MEDIAN returns the arithmetic average of the two middle values.
Example
=MEDIAN(5,12,65,82,9) returns 12.
=MEDIAN(5,12,65,82,9,78) returns 38.50.