yogi,
when i use the following data:
Fund_ID Period_Date L_TWR
245 6/30/1993 0.00%
431 6/30/1993 0.00%
2428 6/30/1993 0.00%
556 6/30/1993 -1.83%
533 6/30/1993 -2.80%
358 6/30/1993 -4.32%
879 6/30/1993 -6.58%
366 6/30/1993 -13.87%
360 6/30/1993 -23.89%
along with the formula:
=(INDEX($C$1:$C$10275,INT(SUBTOTAL(2,$C$1:$C$10275)/2)+IF(ISODD(SUBTOTAL(2,$C$1:$C$10275)),1,0))+INDEX($C$1:$C$10275,INT(SUBTOTAL(2,$C$1:$C$10275)/2)+1))/2
i get the wrong median, 0.0%. but when i write the formula like the following:
=(INDEX(C4:C12,INT(SUBTOTAL(2,C4:C12)/2)+IF(ISODD(SUBTOTAL(2,C4:C12)),1,0))+INDEX(C4:C12,INT(SUBTOTAL(2,C4:C12)/2)+1))/2
i get the correct median, -2.8%?
in the first formula i am using such a large range due to the fact that my data takes up rows 1 thru 10275, but i am really confused because the subtotal count function should allow me to put in the large range?? correct? such as my average calculation =subtotal(1,$C$1:$C$10275)??
can you help me out and maybe offer some reasons as to why it will not calculate correctly when i have the range in absoulte value format ($C$1:$C$10275)??
thanks