"tmason" wrote:
this formula made into an array is not excluding empty cells.
Any ideas?
{=MEDIAN(IF(A$2:A$50000=A2,IF(B$2:B$50000=B2,C$2:C $50000)))}

Array-enter the following formula (press ctrl+shift+Enter, not just Enter):

=MEDIAN(IF(A$2:A$50000=A2,IF(B$2:B$50000=B2,
IF(C$2:C$50000<"",C$2:C$50000))))