Thread: median array help
View Single Post
  #1   Report Post  
tmason tmason is offline
Junior Member
  
Posts: 4
Default
but wait: I don't want the median returned for the cases where col C is empty. Now I'm having trouble with that ...

Quote:
Originally Posted by tmason View Post
figured it out

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