I am trying to make an array formula for a pivot table that works with lots of filters. I'm using Excel 2007, and have had no luck.
I'm using 5 report filters, multiple row labels, and a Count for the values.
I have Year, Month, and unique labels for the rows, and a count of those as the data. I am trying to find the median of the unique labels for each month, with the ability to change the report filters. Is this possible?
I'm using 5 report filters, multiple row labels, and a Count for the values.
I have Year, Month, and unique labels for the rows, and a count of those as the data. I am trying to find the median of the unique labels for each month, with the ability to change the report filters. Is this possible?