Forum Discussion
Combining AVERAGE, MEDIAN and STDEV with IF functions
I have a rather ragged data set, which is split over three sets of columns. In columns A, H and O I have multiple instances of the same numbers representing sample codes. In the other columns I have ...
You could try an array formula using MEDIAN(IF(),IF(),IF()) and STDEV(IF(),IF(),IF()) as explained here:
http://stackoverflow.com/questions/6752724/help-needed-with-median-if-in-excel
Jon