Hi All,
Long time reader, first time poster. I've dug around several boards and am having difficulty finding a solution to my issue. I'm trying to calculate the Median of a data set based on one specific criteria, but I also want that calc to update if I filter my data. I'm familiar with the median(if) array formula:
=MEDIAN(IF($C$3:$C$32=$G3,$E$3:$E$32))
However that doesn't help out with the filtering component. I'm attaching a sample data set where I've got the above formula in column H and a static formula to calc the median of the selected Classification/Season in column I; what I need is a formula that I can apply to the entire range to calculate dynamically. To give a bit more detail, I would want column I to produce the same results if I filter column D to Spring, but update if I change that filter to Summer/Fall/Holiday.
Thank you in advance!
Bookmarks