title: Calculate median of multiple columns
body: <p>In my worksheet, named "Sheet1", Column A through Column J, each column contains various values (so they all have different number of rows).  </p>
  
  <p>How to calculate median of these columns and put the calculated median in row9, and columns M through V?<br>
  I known how to store the calculated median into desired location but really not sure how to calculate median.  </p>
  
  <p>I know this can be solved just by using excel median function, but this is not what I am trying to do. I have over 10+worksheets, so a VBA would be the most efficient. </p>