Insert Median Automatically

[paynestreet]

I have sheet sorted by the month column. WHen the value of mont
changes, I want to insert MEDIAN (C1:C25), than continue on and inser
MEDIAN(C26:...). IT's a simple level break problem but I don't kno
enough VB to do it

 

[Dave Peterson]

How about an easy way...

select your range
Data|Subtotals
Use Sum for function
and only apply it to column C.

Then select column C and do:
edit|replace
what: =subtotal(9,
with: =median(
replace all