title: How do you figure out the MEDIAN of a column taking into account filters?
body: <p>I've recently discovered that you can use <code>SUBTOTAL</code> for various functions which allow you to sum up or find totals of a column, even whilst there are filters being applied to it.</p>
  
  <p>However, the list of functions <code>SUBTOTAL</code> has does not include <code>MEDIAN</code>.</p>
  
  <p>Is it possible to find the median of a column of numbers taking into that some rows have filtered out?</p>