title: median IF in excel
body: <p>looking for similar option for conditional average : =AVERAGEIF(A:A,A2,B:B) but this time for Median in excel. I want to generate Median per IDs in column 1 for large number of subjects</p>
  
  <p>thanks</p>