How do I get median (=median(A1:A50000) to show a result for only filtered
cells? When I autofilter on a different column and the number of visible
cells is reduced by the filter, the median stays the same as the unfiltered
list.

Thanks!