Insert Median Automatically
 

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

--
paynestree
-----------------------------------------------------------------------
paynestreet's Profile: http://www.excelforum.com/member.php...fo&userid=2869
View this thread: http://www.excelforum.com/showthread.php?threadid=48378

Insert Median Automatically
 

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



paynestreet wrote:

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

--
paynestreet
------------------------------------------------------------------------
paynestreet's Profile: http://www.excelforum.com/member.php...o&userid=28694
View this thread: http://www.excelforum.com/showthread...hreadid=483787

--

Dave Peterson