MEDIAN
What Does It Do ?
This function finds the median value of a group of values.
The median is not the average, it is the halfway point where half the numbers in the group are
larger than it and half the numbers are less than it.
If there is no exact median number in the group, the two nearest the half way point are
added and their average is used as the median.
Syntax=MEDIAN(Range1,Range2,Range3… through to Range30)
FormattingNo special formatting is needed.