View Single Post
  #3   Report Post  
tmason tmason is offline
Junior Member
 
Posts: 4
Smile

figured it out

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