Hello all,
My data has many criteria creating different classes or conditions that need
to be grouped together before I perform any statistics on it. As such, I
typically use functions like Daverage, Dsum, and Dcount. However, I need to
calculate the median value for each of these different conditions. Since I
can't find a database median function, I have resorted to presorting the data
and performing the median function on each individual condition (which after
the sort range from 8-15 cells long and this inconsistently varies depending
upon the condition). Whereas this works, it takes forever and it is highly
error prone. Is there any way to do something like a database median
function? Thanks in advance.