MEDIANVISIBLE

MEDIANVISIBLE(rgeValues)
Returns the number in the middle from the visible, non blank cells.

REMARKS
* This function excludes hidden cells caused by AutoFilter, Grouping or that have been Manually Hidden.
* You can use the built-in MEDIAN function -
* You can use the user defined MEDIANIFS function to
* You can use the user defined MEDIANVISIBLEIFS function to
* You can use the add-in AVERAGEVISIBLE function to
* You can use the add-in COUNTVISIBLE function to
* You can use the add-in MAXVISIBLE function to
* You can use the add-in MINVISIBLE function to
* You can use the add-in SUMVISIBLE function to

For instructions on how to add this function to a workbook refer to the page under Inserting Functions