Thread: Multiple arrays in Median function -- VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Scott P Scott P is offline
external usenet poster
  
Posts: 26
Default Multiple arrays in Median function -- VBA
I am trying to implement a function that I built using Excel in VBA. My function is: {=MEDIAN(IF((A1:A100)*(A1:A10<5),B1:B10)} This function tells me: calculate the median for the values in the range B1:B10 for which the corresponding values in A1:A10 are greater than 0 and less than 5.

How can I enable the same functionality in VBA?
Reply With QuoteReply With Quote