I have a column of dates and a column of durations. I have used a pivot
table to work out the average duration by month. However, I also need to
calculate the average after excluding the highest durations for each month.
I have tried PERCENTRANK which works OK for the whole column but I can't
figure out how to group it by month. I also don't want to have to have a
column for each month using lookup or match.