Evening all,
I've created a MEDIAN IF array formula, but when I try to write the non-array equivalent I'm struggling. (I'm assuming it's an AGGREGATE formula?)
The array formula calculates the median by rate type for all cells that have been populated (they may be blank). The formula needs to extend over an expanded range to accommodate any additional rates added.
Attached is a sample data set along with an array solution.
Thanks in advance,
Snook
Bookmarks